Auditing in pluggable database

Hi All,

As part of a hardening of database according to CIS Benchmark for Oracle 12c (I'm checking it on DEV environment before applying it on PROD environment ), I ran the following command in pluggable database

SQL> AUDIT ALL ON SYS.AUD$ BY ACCESS;

and I received an error message:

ERROR at line 1:

ORA-65040: operation not allowed from within a pluggable database

Also, the following query doesn't returns any rows:

SELECT *

FROM DBA_OBJ_AUDIT_OPTS

WHERE OBJECT_NAME='AUD$';

In the root database the audit command was run successfully.

As I know, every pluggable database has his own audit_trail table.