alter table.....drop partition... return insufficient privileges
Hi,
I have 11.2 on linux 64bit and i'm working on the AUD$ table.
I moved it to other tablespace (using SET_AUDIT_TRAIL_LOCATION).
Now I add it partitions by recreate it with partition clause.
I create a job that every X time drop the oldest partition by my preference. This job is not run under sys user, rather by XXX user.
The problem is when the job trying run: alter table sys.aud$ drop partition PARTITION_NAME.
I get insufficient privileges. It got to a point that I gave XXX this privileges: sysdba, dba, alter any table and delete,insert,select,update on aud$.
Nothing helped...
Suggestions?