Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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 '17, 12:25

Serge's gravatar image

Serge
12681016
accept rate: 0%

edited 20 Feb '17, 12:45

Reimer%20Pods's gravatar image

Reimer Pods
4.5k384891


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 '17, 12:44

Reimer%20Pods's gravatar image

Reimer Pods
4.5k384891
accept rate: 11%

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 '17, 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:

×248

question asked: 20 Feb '17, 12:25

question was seen: 1,635 times

last updated: 21 Feb '17, 02:23