（052-25）第43次：2016-01-06星期三

botang

（052-25）上完1Z0-052第8章

1. 
   
2. 
   
3. select   *  from dba_users u where u.username='U5';
   
4. 
   
5. select sysdate+180 from dual;
   
6. 
   
7. alter user u5 account lock;
   
8. 
   
9. 
   
10. 
    
11. alter user u5 account unlock;
    
12. 
    
13. select   *  from dba_users u where u.username='OE';
    
14. 
    
15. alter user u5 account lock password expire ;
    
16. ----
    
17. 
    
18. select * from dba_tab_privs tp where tp.grantee='U5';
    
19. 
    
20. select  * from dba_col_privs cp where cp.grantee='U5';
    
21. 
    
22. create directory dir1 as '/home/oracle/dir1';
    
23. 
    
24. select * from dba_directories;
    
25. 
    
26. grant   read,write,execute on directory dir1 to u5 ;
    
27. --
    
28. grant connect to u6 identified by oracle_4U ;
    
29. 
    
30. ---
    
31. 
    
32. select * from dba_ts_quotas;
    
33. 
    
34. ---
    
35. 
    
36. alter user u5 quota 1M  on users;
    
37. 
    
38. alter user u6 quota 1M on users;
    
39. 
    
40. ----
    
41. 
    
42. select * from dba_sys_privs sp where sp.grantee in ('U5','U6') ;
    
43. 
    
44. 
    
45. ---
    
46. select * from dba_tab_privs sp where sp.grantee in ('U5','U6') ;
    
47. 
    
48. 
    
49. ---
    
50. 
    
51. create role role2 ;
    
52. 
    
53. grant execute on hr.func1  to role2 ;
    
54. 
    
55. select * from role_sys_privs  where role='ROLE2';
    
56. 
    
57. select  * from role_tab_privs  where role='ROLE2' ;
    
58. 
    
59. select * from role_role_privs where role='ROLE2';
    
60. 
    
61. 
    
62. ----
    
63. 
    
64. create role role3 ;
    
65. 
    
66. 
    
67. 
    
68. grant execute on hr.func2 to role3 ;
    
69. 
    
70. grant role3 to role2;
    
71. 
    
72. ----
    
73. 
    
74. select  * from dba_roles r where r.role in ('ROLE2','ROLE3','ROLE4');
    
75. 
    
76. create role role4  identified by oracle_4U;
    
77. 
    
78. grant create table to role4;
    
79. 
    
80. grant role4 to u5;
    
81. 
    
82. --
    
83. 
    
84. select * from  dba_role_privs rp where rp.grantee='U6';
    
85. 
    
86. alter user u6 default role connect ;
    
87. 
    
88. alter user u6 default role none ;
    
89. --
    
90. select * from dba_profiles;
    
91. 
    
92. 
    
93. create profile profile1 limit
    
94. FAILED_LOGIN_ATTEMPTS 1;
    
95. 
    
96. alter user hr profile profile1;
    
97. 
    
98. 
    
99. select * from dba_users u where u.username='HR';
    
100. 
     
101. alter user hr account unlock;
     
102. 
     
103. 
     
104. ALTER PROFILE "PROFILE1" LIMIT PASSWORD_LOCK_TIME 0.000694444;
     
105. 
     
106. ---
     
107. 
     
108. ALTER PROFILE "PROFILE1" LIMIT PASSWORD_LOCK_TIME unlimited
     
109. FAILED_LOGIN_ATTEMPTS DEFAULT;
     
110. 
     
111. 
     
112. 
     
113. ALTER PROFILE "PROFILE1" LIMIT PASSWORD_LIFE_TIME 0.000694444
     
114. PASSWORD_GRACE_TIME 0.000694444;
     
115. 
     
116. 
     
117. ----
     
118. 
     
119. ALTER PROFILE "PROFILE1" LIMIT
     
120. PASSWORD_REUSE_TIME  1;
     
121. 
     
122. 
     
123. ----
     
124. 
     
125. select  * from dba_profiles p where p.profile='PROFILE1'  and p.resource_type='PASSWORD';
     
126. 
     
127. select * from dba_users u where u.username='HR';
     

复制代码