Upgrade from ASA12.0.1.4403 to ASA16.0.0.2322: EXTENV_MAIN and EXTENV_WORKER users

When I made the upgrade my database from 12.0.1.4403 to 16.0.0.2322, EXTENV_MAIN & EXTENV_WORKER users remained.
These users "have limited permissions" in ASA12.
In ASA16, these users do not have any privileges / roles, i.e. CALL sp_displayroles( 'EXTENV_WORKER' ) = null.
Is this correct?
For example, after the upgrade I started getting the following error:

+2,<,7,CONNECT
=,C,7,UID=EXTENV_WORKER;DBN='...'
+2,>,7,CONNECT,7
=,<,7,PREPARE,select ... from "SYS"."SYSOPTION" as "o" ...
=,>,7,PREPARE,65536
=,<,7,EXEC,65536
=,E,7,-121,Permission denied: you do not have permission to select from "SYSOPTION"

sa-16

asked 06 Oct '16, 10:43

Ilia63
1.2k●51●57●82
accept rate: 44%

The access to system views (like SYSOPTION) you can try granting PUBLIC to these users. Only doing so for EXTENV_WORKER may be sufficient.

Of course if the need to utilize system views might be avoided entirely this would become a minor concern. Is that a critical need for this?

I will have to check to see if there was a reason for this change but maybe I could forward a business case for this it may help improve the product.

(11 Oct '16, 09:56) Nick Elson S...

Do you use a login procedure that queries SYSOPTION?

(11 Oct '16, 10:10) Volker Barth

* * Good catch Volker! * *

I hadn't considered that but that would seem to probably explain this. A login procedure that was NOT created with "SQL SECURITY OWNER" then you could easily run into this that way...

Ilia63, do disregard my earlier suggestion. These users would not have been a member of PUBLIC in version 12 either so that suggestion would be incorrect.

(11 Oct '16, 11:49) Nick Elson S...

flat view

Be the first one to answer this question!

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

sa-16 ×261

question asked: 06 Oct '16, 10:43

question was seen: 1,631 times

last updated: 11 Oct '16, 11:49

SAP SQL Anywhere

Upgrade from ASA12.0.1.4403 to ASA16.0.0.2322: EXTENV_MAIN and EXTENV_WORKER users

Follow this question

Related questions