This discussion is archived
14 Replies Latest reply: Nov 7, 2013 10:54 PM by Tushar Lapani RSS

Enable Auditing At Schema level

AKPT Newbie
Currently Being Moderated

Oracle 11g

Unix

Hi DBAs,

 

I am trying to enable auditing on a Schema for all the Select/Insert statements fired on the objects of this schema.

 

 

SQL> audit select on abc_owner by access;

audit select on abc_owner by access

                *

ERROR at line 1:

ORA-00942: table or view does not exist

 

From here i can understand that i will have to mention objects of this schema.But i have around 500 objects in this schema.

 

Is there any option through which i can enable auditing at schema level?

 

 

Thanks,

AKPT

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points