Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using ADMIN_PRIVILEGES from APEX_ACCESS_CONTROL table

NuenhundretfunfundsiebzigMay 16 2014 — edited Jun 13 2014

I have an application in Apex 4.2.3 that uses Admin Privileges to allow different levels of users to view different functions ; ADMIN, EDIT. VIEW

This works fine when the user wants someone to see a page or not see a page

In addition to this, some people can see a page and edit it and other people can see the same page but have read only access

Not sure how to make this work

If I go into the page and say READ ONLY and  enter PSL/SQL condition  :APP_USER  in ('XXXX', 'YYYY',' ZZZZ')

this works fine, but it basically means that I have to hard code the user IDs and edit it every time there is a new user

If I try something like   read only condition  :ADMIN_PRIVILEGES in ('EDIT','VIEW')   ( meaning it is read only unless you have ADMIN rights), it doesn't work

Seems like I ought to be able to code something equivalent to :APP_USER   like :APP_PRIVILEGES but I can't figure out where :APP_USER is set or how to

code :APP_PRIVILEGES

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2014
Added on May 16 2014
12 comments
4,854 views