设为首页收藏本站

Botang唐波's Oracle Station

查看: 1097|回复: 0

第43次:2016-01-28星期四

[复制链接]

745

主题

1118

帖子

8120

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8120
发表于 2016-1-29 09:41:20 | 显示全部楼层 |阅读模式
2016-01-28a.sql:
  1. select  * from dba_objects o where
  2. o.object_name  like 'VERIFY_FUNCTION%';

  3. select  * from dba_profiles  p where p.profile='PROFILE1'
  4.     and p.resource_type='PASSWORD';
  5.    
  6.     alter profile profile1 limit  PASSWORD_VERIFY_FUNCTION verify_function;
  7.    
  8.     alter user hr profile default;

  9. ----

  10. select  count(*) from dba_audit_trail;

  11. select * from dba_audit_trail a  order by a.timestamp  desc;

  12. ---
  13. select  count(*) from dba_audit_trail;

  14. select * from dba_audit_trail a  order by a.timestamp  desc;

  15. select * from dba_views v where v.view_name='DBA_AUDIT_TRAIL';

  16. select  count(*)  from aud$;

  17. select  * from aud$;

  18. select * from dba_tables t where t.table_name='AUD


  19. ;

  20. create tablespace tbsaudit  datafile size 20M autoextend  on;

  21. alter table aud$ move tablespace tbsaudit;

  22. -----
  23. select * from dba_audit_trail a  order by a.timestamp  desc;

  24. ---

  25. select    * from dba_obj_audit_opts;


  26. AUDIT ALL on hr.employees;


  27. select    * from dba_obj_audit_opts;

  28. audit select on hr.employees by access whenever successful;

  29. noAUDIT ALL on hr.employees;
  30. ----
  31. select    * from dba_obj_audit_opts;
  32. ---

  33. select * from dba_audit_trail a   where a.username not in ('DBSNMP','SYSMAN')
  34.     order by a.timestamp  desc;
  35.    
  36.     noaudit select  on hr.employees;
  37.    
  38.     audit select on hr.employees  whenever not successful;
  39.    
  40. ---

  41. select  * from v$xml_audit_trail    where db_user not in ('DBSNMP','SYSMAN','sys')
  42.   order by 6 desc   ;   
  43. ---
  44. audit   update  on hr.employees  by access whenever successful;
  45. ---
  46. select  * from dba_common_audit_trail  where db_user not in ('DBSNMP','SYSMAN','sys')
  47.   order by 6 desc   ;   
  48.   
  49.   ---
  50.   select  * from dba_priv_audit_opts;
  51.   
  52.   select  * from dba_stmt_audit_opts
  53.   minus
  54.    select  * from dba_priv_audit_opts;
  55.    
  56.    
  57.    
  58.    
复制代码



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-12-13 11:54 , Processed in 0.089307 second(s), 24 queries .

快速回复 返回顶部 返回列表