This discussion is archived
1 Reply Latest reply: Apr 18, 2013 12:21 AM by 944276 RSS

APEX_UTIL.EDIT_USER Procedure do not work correctly in APEX 4.0.2.00.07

944276 Newbie
Currently Being Moderated
Hi,
I created user in Apex system without privileges.

Next I want to provision privileges using APEX_UTIL.EDIT_USER Procedure.

But when I try to set p_developer_roles param to ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL in web interface of apex I see the next values: User is workspace administrator - yes; User is a developer - yes; other privilege attributes are NO! When I login I can access to Application Builder but not to SQL Workshop.
In short if i try to provision any developers privileges changes not appearing in web interface, but also i can access to Application Builder if I have that privilege. When I provision SQL:MONITOR:DATA_LOADER privilege I also see:
User is workspace administrator - no; User is a developer - yes; other privilege attributes are NO and I can't access to SQL Workshop!

APEX_UTIL.CREATE_USER Procedure with same values for p_developer_privs param work fine...

Help me to resolve this issue.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points