2014-08-05-2.sql

botang

1. select  * from dict where  table_name like 'DBA%AUDIT%';
   
2. 
   
3. select  *  from DBA_OBJ_AUDIT_OPTS;
   
4. 
   
5. select  *  from DBA_STMT_AUDIT_OPTS;
   
6. 
   
7. select  * from DBA_PRIV_AUDIT_OPTS;
   
8. 
   
9. select  * from dba_audit_trail;
   
10. 
    
11. 
    
12. select * from dba_views v where v.view_name='DBA_AUDIT_TRAIL';
    
13. 
    
14. select  * from dba_tables t where t.owner='SYS' and t.table_name='AUD
    
15. 
    
16. ;
    
17. 
    
18. alter table aud$ move tablespace tbsaudit;
    
19. 
    
20. select  * from dba_tables t where t.owner='SYS' and t.table_name='AUD
    
21. 
    
22. ;
    
23. 
    
24. select  * from dba_audit_trail;
    
25. 
    
26. truncate  table aud$;
    
27. 
    
28. 
    
29. select  * from dba_audit_trail  where username='HR';
    
30. 
    
31. select  * from tlogon;
    
32. 
    
33. select * from dba_source s where s.name='TRGLOGON';
    
34. --ing     ,  ed
    
35. 
    
36. 
    
37. create or replace trigger  trglogon
    
38. after logon on database
    
39. when ( user ='HR' )
    
40. begin
    
41.    insert into tlogon values(   to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'),
    
42.   sys_context('userenv','ip_address'),
    
43.    sys_context('userenv','session_user'));
    
44.    commit;
    
45. end;
    
46. 
    
47. 
    
48. select     a.audit_option     from DBA_STMT_AUDIT_OPTS a
    
49. minus
    
50. select   b.privilege    from DBA_PRIV_AUDIT_OPTS  b ;
    
51. 
    
52. 
    
53. audit table ;
    
54. 
    
55. select     a.audit_option     from DBA_STMT_AUDIT_OPTS a
    
56. minus
    
57. select   b.privilege    from DBA_PRIV_AUDIT_OPTS  b ;
    
58. 
    
59. select  * from dba_audit_trail  where username='HR'  order by timestamp desc ;
    
60. 
    
61. select  * from dba_stmt_audit_opts  where audit_option='TABLE';
    
62. 
    
63. noaudit table;
    
64. 
    
65. audit table by hr   by access  whenever  successful ;
    
66. 
    
67. 
    
68. alter user sh identified by oracle_4U account unlock;
    
69. 
    
70. grant select  on hr.employees to sh ;
    
71. 
    
72. 
    
73. audit select  on hr.employees    by  session  ;
    
74. 
    
75. select  *  from DBA_OBJ_AUDIT_OPTS;
    
76. 
    
77. noaudit  select  on hr.employees;
    
78. 
    
79. audit select  on hr.employees    by  access   whenever  successful ;
    
80. 
    
81. select  * from dba_audit_trail   where     username='SYSTEM'     order by timestamp desc ;
    
82. 
    
83. grant update(salary)  on hr.employees to sh;
    
84. 
    
85. ---audit  update(salary)  on hr.employees  ;
    
86. 
    
87. grant  select any table to sh ;
    
88. 
    
89. -----
    
90. audit select  any table by sh by session   whenever successful;
    
91. 
    
92. 
    
93. select  * from DBA_PRIV_AUDIT_OPTS;
    
94. 
    
95. select  * from dba_audit_trail  where username='SH'  order by timestamp desc ;
    
96. 
    
97. 
    
98. select  * from v$xml_audit_trail  order by  extended_timestamp  desc;
    
99. 
    
100. select  * from dba_audit_trail  where username='SH'  order by timestamp desc ;
     
101. 
     
102. select * from dba_common_audit_trail   where db_user='HR'  order by  extended_timestamp  desc       ;
     
103. 
     
104. select  *  from DBA_OBJ_AUDIT_OPTS;
     
105. 
     
106. audit update on hr.employees   whenever successful;
     
107. 
     
108. create table tvalue as select     *  from   tlogon where 1=2;
     
109. 
     
110. 
     
111. select  * from  tvalue;
     
112. 
     
113. alter table tvalue add  ( audit_oldvalue  number(8,2) ,  audit_newvalue   number(8,2)) ;
     
114. 
     
115. 
     
116. create or replace trigger   trgvalue
     
117. after update of  salary on  hr.employees
     
118. referencing new as new old as old
     
119. for each row
     
120. begin
     
121.   if :old.salary != :new.salary then
     
122.      insert into     tvalue
     
123.       values (  to_char(sysdate,'YYYY-MM-DD:HH24:MI:SS'),
     
124.                      sys_context('userenv','ip_address'),
     
125.                     sys_context('userenv', 'session_user'),
     
126.                       :old.salary,
     
127.                     :new.salary
     
128.                );      
     
129.   end if;
     
130. end;
     
131. 
     
132. 
     
133. 
     
134. 
     

复制代码

Guiyuan

唐老师，我们每次上课的笔记能不能压缩成一个 ZIP 包;1方便我们下载；2.代码的有些字符直接放论坛会被转义，变成表情；3.这样就可以一节课就一个贴，我们把上课没有理解的问题就在当天的帖子下面追加提问，您看这样行吗？

botang

Guiyuan 发表于 2014-8-6 10:01
唐老师，我们每次上课的笔记能不能压缩成一个 ZIP 包;1方便我们下载；2.代码的有些字符直接放论坛会被转义 ...

OK