第42次：2016-01-04星期一

botang

2016-01-04a.sql：

1. select  * from dba_users where username='HR';
   
2. 
   
3. alter user hr identified by oracle_4U account unlock;
   
4. 
   
5. select sysdate+180 from dual;
   
6. 
   
7. select  * from user$ u where u.name='SYS';
   
8. --48DF04E7BAB11018
   
9. alter user hr identified by oracle_4U;
   
10. --A586E74A0FA6A0BC
    
11. 
    
12. grant sysoper to hr ;
    
13. 
    
14. select  * from dba_sys_privs  sp where sp.grantee='OPS$ORACLE'  order by 2;
    
15. 
    
16. select  * from dba_tab_privs  tp where tp.grantee='OPS$ORACLE'  ;
    
17. 
    
18. select  * from dba_col_privs  cp where cp.grantee='OPS$ORACLE';
    
19. 
    
20. select * from dba_role_privs  rp where rp.grantee='OPS$ORACLE';
    
21. 
    
22. ---
    
23. 
    
24. 
    
25. 
    
26.   select  count(distinct  sp.privilege)      from dba_sys_privs sp;
    
27. 
    
28. select  distinct  sp.privilege from dba_sys_privs sp order by 1 ;
    
29. 
    
30. grant create table  to u1;
    
31. 
    
32. select  * from dba_sys_privs  sp where sp.grantee='U1'  order by 2;
    
33. 
    
34. select  * from dba_tab_privs  tp where tp.grantee='U1'  ;
    
35. 
    
36. select  * from dba_col_privs  cp where cp.grantee='U1';
    
37. 
    
38. select * from dba_role_privs  rp where rp.grantee='U1';
    
39. 
    
40. select  * from dba_ts_quotas;
    
41. 
    
42. alter user u1 quota 0 on example;
    
43. 
    
44. select * from dba_roles;
    
45. 
    
46. select * from role_sys_privs  rsp  where rsp.role='RESOURCE';
    
47. 
    
48. select  * from role_tab_privs  rtp where rtp.role='RESOURCE';
    
49. 
    
50. select * from role_role_privs  rrp where rrp.role='RESOURCE';
    
51. 
    
52. select  * from role_wm_privs  rwp where rwp.role='RESOURCE';
    
53. 
    
54. grant resource to ops$oracle;
    
55. 
    
56. --
    
57. revoke create table from u1;
    
58. 
    
59. revoke resource  from ops$oracle;
    
60. 
    
61. ---
    
62. select * from role_sys_privs  rsp  where rsp.role='CONNECT';
    
63. 
    
64. select  * from role_tab_privs  rtp where rtp.role='CONNECT';
    
65. 
    
66. select * from role_role_privs  rrp where rrp.role='CONNECT';
    
67. 
    
68. create user u2 identified by oracle_4U ;
    
69. ---
    
70. grant create session to u3 identified by oracle_4U ;
    
71. 
    
72. grant connect to u4 identified by oracle_4U;
    
73. 
    
74. --
    
75. 
    
76. select username from dba_users order by 1 desc ;
    
77. 
    
78. 
    
79. 
    
80. 
    

复制代码

2016-01-04b.sql：

1. select  * from dba_users where username='HR';
   
2. 
   
3. alter user hr identified by oracle_4U account unlock;
   
4. 
   
5. select sysdate+180 from dual;
   
6. 
   
7. select  * from user$ u where u.name='SYS';
   
8. --48DF04E7BAB11018
   
9. alter user hr identified by oracle_4U;
   
10. --A586E74A0FA6A0BC
    
11. 
    
12. grant sysoper to hr ;
    
13. 
    
14. select  * from dba_sys_privs  sp where sp.grantee='OPS$ORACLE'  order by 2;
    
15. 
    
16. select  * from dba_tab_privs  tp where tp.grantee='OPS$ORACLE'  ;
    
17. 
    
18. select  * from dba_col_privs  cp where cp.grantee='OPS$ORACLE';
    
19. 
    
20. select * from dba_role_privs  rp where rp.grantee='OPS$ORACLE';
    
21. 
    
22. ---
    
23. 
    
24. 
    
25. 
    
26.   select  count(distinct  sp.privilege)      from dba_sys_privs sp;
    
27. 
    
28. select  distinct  sp.privilege from dba_sys_privs sp order by 1 ;
    
29. 
    
30. grant create table  to u1;
    
31. 
    
32. select  * from dba_sys_privs  sp where sp.grantee='U1'  order by 2;
    
33. 
    
34. select  * from dba_tab_privs  tp where tp.grantee='U1'  ;
    
35. 
    
36. 
    
37. 
    
38. 
    
39. select  * from dba_col_privs  cp where cp.grantee='U1';
    
40. 
    
41. select * from dba_role_privs  rp where rp.grantee='U1';
    
42. 
    
43. select  * from dba_ts_quotas;
    
44. 
    
45. alter user u1 quota 0 on example;
    
46. 
    
47. select * from dba_roles;
    
48. 
    
49. select * from role_sys_privs  rsp  where rsp.role='RESOURCE';
    
50. 
    
51. select  * from role_tab_privs  rtp where rtp.role='RESOURCE';
    
52. 
    
53. select * from role_role_privs  rrp where rrp.role='RESOURCE';
    
54. 
    
55. select  * from role_wm_privs  rwp where rwp.role='RESOURCE';
    
56. 
    
57. grant resource to ops$oracle;
    
58. 
    
59. --
    
60. revoke create table from u1;
    
61. 
    
62. revoke resource  from ops$oracle;
    
63. 
    
64. ---
    
65. select * from role_sys_privs  rsp  where rsp.role='CONNECT';
    
66. 
    
67. select  * from role_tab_privs  rtp where rtp.role='CONNECT';
    
68. 
    
69. select * from role_role_privs  rrp where rrp.role='CONNECT';
    
70. 
    
71. create user u2 identified by oracle_4U ;
    
72. ---
    
73. grant create session to u3 identified by oracle_4U ;
    
74. 
    
75. grant connect to u4 identified by oracle_4U;
    
76. 
    
77. --
    
78. 
    
79. select username from dba_users order by 1 desc ;
    
80. 
    
81. --------
    
82. --------
    
83. grant select any table to u1;
    
84. grant select_catalog_role to ops$oracle;
    
85. 
    
86. ---
    
87. 
    
88. select  * from dba_sys_privs  sp where sp.grantee='HR'  order by 2;
    
89. 
    
90. select  * from dba_tab_privs  tp where tp.grantee='HR'  ;
    
91. 
    
92. select  * from dba_col_privs  cp where cp.grantee='HR';
    
93. 
    
94. select * from dba_role_privs  rp where rp.grantee='HR';
    
95. 
    
96. ---
    
97. 
    
98. grant select_catalog_role to hr;
    
99. 
    
100. ---
     
101. 
     
102. select  * from dba_tab_privs  tp where tp.grantee='PUBLIC'   and tp.grantor='HR' ;
     
103. 
     
104. grant create procedure to u3;
     
105. ---
     
106. create role role1;
     
107. 
     
108. grant select  on hr.employees to role1;
     
109. 
     
110. select  * from role_tab_privs rtp where rtp.role='ROLE1';
     
111. 
     
112. grant role1 to u4;
     
113. 
     
114. grant create procedure to u4;
     
115. 
     
116. --
     
117. select  * from role_role_privs rrp where rrp.role='SELECT_CATALOG_ROLE';
     
118. ---
     
119. select * from dba_users where username='HR';
     
120. 
     
121. 
     
122. 
     
123. 
     
124. 
     
125. 
     

复制代码