Home » RDBMS Server » Security » NOAUDIT (Oracle 11g/Windows 7)
NOAUDIT [message #607386] |
Wed, 05 February 2014 06:49  |
prejib
Messages: 126 Registered: March 2009 Location: India
|
Senior Member |
|
|
Hi ,
I have given the noaudit statement for DMLs as given below . still I am getting the belowresult. Can you please help me how can I disable the select table audit and other DMLs also ?
SQL> noaudit all;
Noaudit succeeded.
SQL> noaudit select any table;
Noaudit succeeded.
SQL> set linesize 600
SQL> select
2 ACTION#,
3 SQLTEXT
4 from sys.aud$ where userid='TEST' and rownum<10 ;
ACTION# SQLTEXT
---------- --------------------------------------------------------------------------------
100
103 select sid from V$SESSION where audsid = ( select USERENV('SESSIONID') from dua
103 select sid from V$SESSION where audsid = ( select USERENV('SESSIONID') from dua
103 select sid from V$SESSION where audsid = ( select USERENV('SESSIONID') from dua
103 select sid from V$SESSION where audsid = ( select USERENV('SESSIONID') from dua
103 select sid from V$SESSION where audsid = ( select USERENV('SESSIONID') from dua
103 select sid from V$SESSION where audsid = ( select USERENV('SESSIONID') from dua
103 select sid from V$SESSION where audsid = ( select USERENV('SESSIONID') from dua
103 SELECT * FROM session_roles where role='DBA'
9 rows selected.
|
|
|
|
|
Goto Forum:
Current Time: Thu Apr 17 03:29:42 CDT 2025
|