| How can FGA audit the statements of sysdba [message #555924] |
Wed, 30 May 2012 00:00  |
 |
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?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
