on 2017 Feb 20 12:25 PM
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.
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.