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

Improve this question
2
  • 2
    How did you create these users? Using the database command create user? Or as users within APEX?
    – Chris Saxon
    Commented Mar 1, 2018 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
    Commented Mar 1, 2018 at 22:58

1 Answer 1

Reset to default
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.

Improve this answer
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
    Commented Mar 1, 2018 at 23:35
  • I don't think Apex users have privileges on database objects directly — you need to control access in the application.
    – Jack Douglas
    Commented Mar 2, 2018 at 10:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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