1 Reply Latest reply: Apr 18, 2013 2:21 AM by 944276 RSS

    APEX_UTIL.EDIT_USER Procedure do not work correctly in APEX 4.0.2.00.07

    944276
      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.