*总结：
*1.SQL> audit table by scott; -- 对scott下的所有表进行监控，包括create，truncate，drop，select操作 ，查询语句
*select * from dba_audit_trail t where t.owner = 'SCOTT';
*select * from dba_audit_object;
*2.SQL> audit all on emp1 by access; -- 对象审计，审计emp1表，哪些表已经被审计可以查询
*select * from dba_obj_audit_opts t;
*3.对表做了哪些操作
*SQL> alter system set audit_sys_operations=TRUE scope=spfile;
*SQL> alter system set audit_trail=db scope=spfile;
*重启oracle
*SQL> exec dbms_fga.add_policy(object_name=>'dept',policy_name=>'chk_dept',statement_types=>'insert,update,delete,select');
*查看操作语句，查询
*select * from dba_audit_policies;
*select db_user,sql_text,t.* from dba_fga_audit_trail t;
*1.SQL> audit table by scott; -- 对scott下的所有表进行监控，包括create，truncate，drop，select操作 ，查询语句
*select * from dba_audit_trail t where t.owner = 'SCOTT';
*select * from dba_audit_object;
*2.SQL> audit all on emp1 by access; -- 对象审计，审计emp1表，哪些表已经被审计可以查询
*select * from dba_obj_audit_opts t;
*3.对表做了哪些操作
*SQL> alter system set audit_sys_operations=TRUE scope=spfile;
*SQL> alter system set audit_trail=db scope=spfile;
*重启oracle
*SQL> exec dbms_fga.add_policy(object_name=>'dept',policy_name=>'chk_dept',statement_types=>'insert,update,delete,select');
*查看操作语句，查询
*select * from dba_audit_policies;
*select db_user,sql_text,t.* from dba_fga_audit_trail t;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769538/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
