可以对你需要监视的表进行审计。 如: 1、设参数 SQL>alter system set AUDIT_TRAIL=DB scope=spfile;2、停启数据库 oracle>sqlplus '/ as sysdba' SQL>shutdown immediate; SQL>startup;3、设置审计 AUDIT SELECT ON table1 BY ACCESS;4、查看dba_audit_trail,确定table1是否被访问 select * from dba_audit_trail;
如:
1、设参数
SQL>alter system set AUDIT_TRAIL=DB scope=spfile;2、停启数据库
oracle>sqlplus '/ as sysdba'
SQL>shutdown immediate;
SQL>startup;3、设置审计
AUDIT SELECT ON table1 BY ACCESS;4、查看dba_audit_trail,确定table1是否被访问
select * from dba_audit_trail;