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