SQL> create user shiyuebi identified by oracle;
oracle 10g开启审计
原创a3z2008 博主文章分类:ORACLE基础知识 ©著作权
©著作权归作者所有:来自51CTO博客作者a3z2008的原创作品,请联系作者获取转载授权,否则将追究法律责任
SQL> create user shiyueerp identified by oracle;
SQL> grant connect,resource to shiyuebi;
SQL> grant connect,resource to shiyueerp;
SQL> conn shiyuebi/oracle
SQL> 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 sysdba
SQL> alter system set audit_file_dest=’/u02/shiyueau’ scope=spfile;
SQL> alter system set audit_trail=db,extended scope=spfile;
SQL> shutdown immediate
SQL> startup
SQL> audit select on shiyuebi.ctc by access;
SQL> conn shiyueerp/oracle
SQL> select * from shiyuebi.ctc;
SQL> select name from shiyuebi.ctc where id=1;
SQL> conn sys/oracle as sysdba
SQL> desc dba_audit_trail;
SQL> select username,sql_text from dba_audit_trail;
上一篇:ORACLE 10g手动配置监听
下一篇:RMAN备份恢复实例
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
oracle 10g中开启flashback功能
oracle 10g中开启flashback功能
oracle 10g 开启flashback功能 -
oracle 10g 地址
点击链接使用迅雷即可下载。 4种包的介绍: ***_d
oracle database