ITPub博客

首页 > 数据库 > Oracle > audit

audit

原创 Oracle 作者:yaoronghui2005 时间:2009-09-24 06:47:53 0 删除 编辑
http://hi.baidu.com/edeed/blog/item/dc7c0cd75f667adea144dfea.html[@more@]

by session --drop any table not audit the tables by self user

162. You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
A) One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his
session.
B) One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C) One audit record is created for each successful DROP TABLE command executed by any user to drop tables
owned by SCOTT.
D) One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in
his session.
E) One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/450962/viewspace-1027293/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    153
  • 访问量
    176623