Database Administration (MOSC)

MOSC Banner

select privilege on unified_audit_trail in autonomous database in OCI

Hello,

I am not able to grant the select privilege on unified_audit_trail as ADMIN user in the autonomous database (Oracle Cloud). I do need a direct grant on unified_audit_trail to use a select ... from in a cursor definition in a stored procedure. I assumed that the ADMIN user should be able to grant the privilege as dba_tab_privs says:

select * from dba_tab_privs where table_name = 'UNIFIED_AUDIT_TRAIL';

GRANTEE       OWNER    TABLE_NAME          GRANTOR  PRIVILEGE  GRANTABLE

-------------- --------- -------------------- --------- ----------- ---------

ADMIN         AUDSYS   UNIFIED_AUDIT_TRAIL AUDSYS   READ       YES

AUDIT_ADMIN   AUDSYS   UNIFIED_AUDIT_TRAIL AUDSYS   READ       NO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center