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


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?






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