Oracle Database Discussions

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