Required Database Privileges
To integrate APEX with a Fusion Applications environment, the user specified in the Database Tools connection may require the following privileges. Note that the ADMIN user of an APEX instance (Autonomous Database) already has these privileges.
| Privilege | Requirement |
|---|---|
| GRANT CONNECT TO <user> | To create a session (log in to the database). |
| GRANT EXECUTE ON DBMS_CLOUD TO <user> | To execute
DBMS_CLOUD.{CREATE,UPDATE,DROP}_CREDENTIAL.
|
| GRANT APEX_ADMINISTRATOR_ROLE TO <user> | To execute
APEX_INSTANCE_ADMIN.{GET,SET)_PARAMETER.
|
|
GRANT CREATE PUBLIC SYNONYM TO <user> GRANT DROP PUBLIC SYNONYM TO <user> |
To create and drop public synonyms. |