DBA is trying to setup a job to purge table “sys.aus$” periodically with following sql and errors:
SQL> show user; USER is "SYSTEM" SQL> delete FROM sys.aud$ WHERE NTIMESTAMP# < sysdate -31; ERROR at line 1: ORA-01031: insufficient privileges
Solution
Though SYSTEM user has DBA role privilege, the specific object privilege is still needed in this case:
SQL> grant delete on sys.aud$ to system container=all; Grant succeeded.
SQL> delete FROM sys.aud$ WHERE NTIMESTAMP# < sysdate -31; 2006228 rows deleted. SQL> commit; Commit complete.
Make DBA Life Easy 