SVRMGR> connect sys/change_on_install
连接成功。SVRMGR> show parameter audit_trail
NAME TYPE VALUE
----------------------------------- ------- ------------------------------
audit_trail 字符串 TRUESVRMGR> select object_name,del,ins,sel,upd from dba_obj_audit_opts where owner='
scott';
OBJECT_NAME DEL INS SEL UPD
------------------------------ ----- ----- ----- -----
已选择0行。SVRMGR> audit INSERT on scott.emp by access whenever successful;
语句已处理。SVRMGR> select object_name,del,ins,sel,upd from dba_obj_audit_opts where owner='
scott';
OBJECT_NAME DEL INS SEL UPD
------------------------------ ----- ----- ----- -----
已选择0行。SVRMGR> rem ?commitSVRMGR> commit
语句已处理。SVRMGR> select object_name,del,ins,sel,upd from dba_obj_audit_opts where owner='
scott';
OBJECT_NAME DEL INS SEL UPD
------------------------------ ----- ----- ----- -----
已选择0行。
WHY????
连接成功。SVRMGR> show parameter audit_trail
NAME TYPE VALUE
----------------------------------- ------- ------------------------------
audit_trail 字符串 TRUESVRMGR> select object_name,del,ins,sel,upd from dba_obj_audit_opts where owner='
scott';
OBJECT_NAME DEL INS SEL UPD
------------------------------ ----- ----- ----- -----
已选择0行。SVRMGR> audit INSERT on scott.emp by access whenever successful;
语句已处理。SVRMGR> select object_name,del,ins,sel,upd from dba_obj_audit_opts where owner='
scott';
OBJECT_NAME DEL INS SEL UPD
------------------------------ ----- ----- ----- -----
已选择0行。SVRMGR> rem ?commitSVRMGR> commit
语句已处理。SVRMGR> select object_name,del,ins,sel,upd from dba_obj_audit_opts where owner='
scott';
OBJECT_NAME DEL INS SEL UPD
------------------------------ ----- ----- ----- -----
已选择0行。
WHY????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货