oracle 10g开启审计

火冰狐

　　SQL> create user shiyuebi>SQL> create user shiyueerp>SQL> grant connect,resource to shiyuebi;SQL> grant connect,resource to shiyueerp;SQL> conn shiyuebi/oracleSQL> create table ctc (ID int,name varchar2(10));SQL> insert into ctc values(1,’zhangsan’);SQL> grant select on ctc to shiyueerp;SQL> conn sys/oracle as sysdbaSQL>>SQL>>SQL> shutdown immediateSQL> startupSQL> audit select on shiyuebi.ctc by access;SQL> conn shiyueerp/oracleSQL> select * from shiyuebi.ctc;SQL> select name from shiyuebi.ctc where>SQL> conn sys/oracle as sysdbaSQL> desc dba_audit_trail;SQL> select username,sql_text from dba_audit_trail;