Database Administration (MOSC)

MOSC Banner

execute AUDIT SESSION command by non-SYS id

edited Sep 7, 2017 6:01PM in Database Administration (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center