Skip to content
January 14, 2011 / doganay

DISABLE ALL OPEN AUDITS

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
SQL> spool run.sql
select
'no audit ' || audit_option || ' by ' ||
user_name || ' by ' || success || ';'
from dba_stmt_audit_opts
union
select
'no audit ' || PRIVILEGE || ' by ' ||
user_name || ' by ' || success || ';'
from dba_priv_audit_opts;
SQL> spool off
SQL> @run
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: