Disabling auditing for the SYS.AUD$ table - Amazon Relational Database Service

Disabling auditing for the SYS.AUD$ table

To disable auditing on the database audit trail table SYS.AUD$, use the Amazon RDS procedure rdsadmin.rdsadmin_master_util.noaudit_all_sys_aud_table. This procedure takes no parameters.

The following query returns the current audit configuration for SYS.AUD$ for a database:

SELECT * FROM DBA_OBJ_AUDIT_OPTS WHERE OWNER='SYS' AND OBJECT_NAME='AUD$';

The following command disables audit of ALL on SYS.AUD$.

EXEC rdsadmin.rdsadmin_master_util.noaudit_all_sys_aud_table;

For more information, see NOAUDIT (traditional auditing) in the Oracle documentation.