Audit schema object

AUDIT object_privilege ON schema.object_name

[BY SESSION [WHENEVER [NOT SUCESSFULL]
[BY ACCESS [WHENEVER [NOT SUCESSFULL]

eg : audit select on scott.emp by access;

audit sql statements

eg : audit select table whenever not sucessfull