How can FGA audit the statements of sysdba [message #555924] |
Wed, 30 May 2012 00:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2eddf9a9f7c38e4e130f8c7b02b23e09?s=64&d=mm&r=g) |
supersimba2011
Messages: 4 Registered: May 2012
|
Junior Member |
|
|
Hi:
I find the dbms_fga can not audit the statements of sysdba.
eg:
scott:
SQL> select * from emp;
I
----------
1
2
3
SQL> select db_user,timestamp,sql_text from dba_fga_audit_trail;
DB_USER TIMESTAMP SQL_TEXT
------------------------------ ----------------- ----------------------------------------------------------------------------------------------------
SCOTT 20111103 18:14:42 select * from emp
============================================================================
SQL> show user
USER is "SYS"
SQL> select * from scott.emp;
I
----------
1
2
3
SQL>
SQL> /
DB_USER TIMESTAMP SQL_TEXT
------------------------------ ----------------- ----------------------------------------------------------------------------------------------------
SCOTT 20111103 18:14:42 select * from emp
How can i audit the statements of sys?
|
|
|
|
|
|
|
|
|