cancel
Showing results for 
Search instead for 
Did you mean: 

What sense in EXTENV_MAIN and EXTENV_WORKER?

0 Kudos
1,886

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

reimer_pods
Participant
0 Kudos

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.

VolkerBarth
Contributor
0 Kudos

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"