1

Within oracle apex 5.1.2 I have been experimenting with security features relating to grants, using the managing user tab i managed to create users and allocated these users end-user account types. My problem begins when I attempt to GRANT these users privileges to defined tables within my schema I hit an error when I for instance:

GRANT SELECT ON *SCHEMA.*TABLE TO CREATEDUSER 

ORA-01917: user or role ' CREATEDUSER' does not exist

I can't quite workout why this is happening, I've researched the issue however I have not come across an understandable resolution

2
  • 2
    How did you create these users? Using the database command create user? Or as users within APEX? Mar 1 '18 at 17:44
  • These users were created within apex via the user accounts form found on the Managing users page. As it seems with this school account I cannot create new users via SQL COMMAND due to me having insufficient privileges, meaning I didn't really know how to test whether my grants worked or not.
    – BOB
    Mar 1 '18 at 22:58
2

The simple answer is because Apex users are not database users.

…APEX users are not database users. Apex users are pseudo users that have schema grants by the Apex administration area

Apex users are stored in Apex tables and you can create groups to restrict access to various parts of an application.

2
  • With these groups will I have the ability to test the privileges users can have on a table using sql? as I know through using an application I could just simply create an access control administration page however this seems too easy and simplistic?
    – BOB
    Mar 1 '18 at 23:35
  • I don't think Apex users have privileges on database objects directly — you need to control access in the application. Mar 2 '18 at 10:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.