This content has been marked as final. Show 3 replies
In google you can find some many ways to ask the V$SQL view, but to control unauthorized access you can activate the BBDD audit.
I don't know your Oracle Release but, for instance, in 11.1 you have many Audit features.
You'll find enclosed a link which explain how to Audit the access on the Database, you'll find also there a way to Audit the Statements:
Hope this help.
to view sql _text
SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE;
ORACLE instance shut down.
Then with dba users run
DBMS_FGA.ADD_POLICY(object_schema => 'schema_name',
object_name => 'table_name',
policy_name => 'AUDIT_123',
audit_condition => 'SYS_CONTEXT (''USERENV'',''IP_ADDRESS'')!= ''10.0.0.0''', -- here you can set which ip you want to audit or which you dont want audit
…enable => TRUE);
your audit information are on table dba_fga_audit_trail.
note: information may take to much information and space on disk. because FGA audit all transactions on your system.