When I made the upgrade my database from 12.0.1.4403 to 16.0.0.2322, EXTENV_MAIN & EXTENV_WORKER users remained.
|
When I made the upgrade my database from 12.0.1.4403 to 16.0.0.2322, EXTENV_MAIN & EXTENV_WORKER users remained.
|
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Question tags:
question asked: 06 Oct '16, 10:43
question was seen: 1,379 times
last updated: 11 Oct '16, 11:49
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.
Do you use a login procedure that queries SYSOPTION?
* * 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.