（52-25）第42次：2016-01-27星期二

botang

（52-25）上完1Z0-052第8章
2016-01-26a.sql：

1. grant connect to user1 identified by oracle_4U;
   
2. 
   
3. select  * from dba_tab_privs tp where tp.grantee='USER1';
   
4. 
   
5. grant select  on hr.employees to user1;
   
6. 
   
7. select  * from dba_tab_privs tp where tp.grantee='USER1';
   
8. 
   
9. revoke select  on hr.employees  from user1;
   
10. 
    
11. select  * from dba_tab_privs tp where tp.grantee='USER1';
    
12. 
    
13. grant create procedure to user1;
    
14. 
    
15. 
    
16. 
    
17. ---
    
18. select * from dba_roles;
    
19. 
    
20. create role role1 ;
    
21. 
    
22. select  * from role_sys_privs  rsp where rsp.role='ROLE1';
    
23. 
    
24.   select  * from role_tab_privs rtp where rtp.role='ROLE1';
    
25. 
    
26. select  * from role_role_privs rrp where rrp.role='ROLE2';
    
27. 
    
28. ---
    
29. grant select  on hr.employees to  role1;
    
30. 
    
31. grant role1 to user1;
    
32. 
    
33. revoke role1 from user1;
    
34. 
    
35. revoke execute on hr.proc05208_b  from user1;
    
36. 
    
37. revoke create procedure from user1;
    
38. 
    
39. select  * from dba_role_privs rp where rp.grantee='USER1';
    
40. 
    
41. select  * from dba_tab_privs tp where tp.grantee='USER1';
    
42. 
    
43. select  * from dba_sys_privs tp where tp.grantee='USER1';
    
44. 
    
45. select  * from dba_col_privs tp where tp.grantee='USER1';
    
46. ---
    
47. grant select any table to user1 with admin option;
    
48. 
    
49. ---
    
50. create user user2 identified by oracle_4U ;
    
51. 
    
52. grant connect to user2;
    
53. ---
    
54. select  * from dba_role_privs rp where rp.grantee='USER2';
    
55. 
    
56. select  * from dba_tab_privs tp where tp.grantee='USER2';
    
57. 
    
58. select  * from dba_sys_privs tp where tp.grantee='USER2';
    
59. 
    
60. select  * from dba_col_privs tp where tp.grantee='USER2';
    
61. 
    
62. ---
    
63. revoke select  any table from user1;
    
64. 
    
65. revoke select  any table from user2;
    
66. 
    
67. ---
    
68. 
    
69. grant role1 to user1 with admin option;
    
70. 
    
71. ----
    
72. revoke role1 from user1;
    
73. ---
    
74. 
    
75. revoke role1 from user2;
    
76. 
    
77. grant select  on hr.employees  to public;
    
78. 
    
79. ---
    
80. revoke  select  on hr.employees   from public;
    
81. ----
    
82. db2 --XML
    
83. 
    
84. ---
    
85. 
    
86. create role role2;
    
87. 
    
88. 
    
89. grant role1 to role2;
    
90. ---
    
91. grant role2 to role1;
    
92. ----
    
93. 
    
94. grant connect to user3 identified by oracle_4U;
    
95. 
    
96. grant role2 to user3;
    
97. 
    
98. ---
    
99. revoke select  on hr.employees from role1;
    
100. 
     
101. grant select  on hr.employees  to role1;
     
102. ---
     
103. 
     
104. select  * from dba_roles;
     
105. 
     
106. 
     
107. create role role3 identified by oracle_4U;
     
108. 
     
109. ---
     
110. 
     
111. select  * from dba_role_privs  rp where rp.grantee='USER3';
     
112. 
     
113. alter user user3 default role connect;
     
114. 
     
115. revoke role2 from user3;
     
116. 
     
117. grant role2 to role3 ;
     
118. 
     
119. grant role3 to user3;
     
120. 
     
121. alter user user3 default role  connect;

复制代码

2016-01-26b.sql：

1. select  * from dba_profiles  where profile='DEFAULT';
   
2. 
   
3. create profile profile1 limit CPU_PER_SESSION 100;
   
4. 
   
5. select  * from dba_users where username='HR';
   
6. 
   
7. alter user hr profile profile1;
   
8. 
   
9. alter profile profile1 limit  CPU_PER_SESSION  default;
   
10. 
    
11. select * from dba_users where username='HR';
    
12. 
    
13. ---
    
14. select  * from dba_profiles  where profile='PROFILE1'  and resource_type <>'KERNEL';
    
15. ---
    
16. alter user  hr account unlock;
    
17. 
    
18. ----
    
19. ALTER PROFILE "PROFILE1" LIMIT PASSWORD_REUSE_MAX 1
    
20. PASSWORD_REUSE_TIME 1;
    
21. 
    

复制代码