New DB created by SA17 has 2 users EXTENV_MAIN and EXTENV_WORKER that couldn't be deleted. Meanwhile in chm, pdf and online doc there is no a word about EXTENV_MAIN and EXTENV_WORKER.

asked 20 Feb, 12:25

Serge's gravatar image

Serge
1266715
accept rate: 0%

edited 20 Feb, 12:45

Reimer%20Pods's gravatar image

Reimer Pods
4.2k334481


I've found the following here: SyBools online

EXTENV_MAIN and EXTENV_WORKER users EXTENV_MAIN and EXTENV_WORKER are used for external environment support. They are for internal use only and have limited permissions. See SQL Anywhere external environment support.

permanent link

answered 20 Feb, 12:44

Reimer%20Pods's gravatar image

Reimer Pods
4.2k334481
accept rate: 12%

For v16 and above (with a newly created database), it seems somewhat different:

EXTENV_MAIN and EXTENV_WORKER are listed in SYS.SYSUSER with user_type 12, i.e. "12 Mutable and removable user". However, I cannot remove those with a DROP USER statement.

select user_id, user_name, user_type
from sysuser where user_name like 'EXTENV%'

returns

user_id;user_name;user_type
2147484649;'EXTENV_MAIN';12
2147484650;'EXTENV_WORKER';12

drop user "EXTENV_MAIN";

returns SQLCODE -1536: "Could not execute statement. Invalid user ID or role name 'EXTENV_MAIN' specified"

(21 Feb, 02:22) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×82

question asked: 20 Feb, 12:25

question was seen: 102 times

last updated: 21 Feb, 02:23