execute AUDIT SESSION command by non-SYS id
Hello
i need to enable a database ID (not sys and not system) to execute audit session command. I am getting this error in 11.2.0.4
>AUDIT SESSION BY &&1;
Enter value for 1: test1
AUDIT SESSION BY test1
*
ERROR at line 1:
ORA-01031: insufficient privileges
Even though I am connected by the ID which was granted "AUDIT ANY" privilege (via a role as well as directly). Is there a different privilege that this ID needs to be able to turn on auditing?
Or can it only be done by SYS?
Thank you