第43次：2015-08-19星期三

botang

2015-08-19a.sql：

1. select * from dba_users where username='SYSTEM';
   
2. 
   
3. alter user sysman identified by oracle_4U;
   
4. 
   
5. select * from user$ where name ='SYS';
   
6. 
   
7. 48DF04E7BAB11018;
   
8. 
   
9. select  * from dba_sys_privs sp where sp.grantee='SYSTEM';
   
10. 
    
11. select  * from dba_role_privs rp where rp.grantee='SYSTEM';
    
12. 
    
13. grant sysdba to hr;
    
14. 
    
15. revoke sysdba from hr;
    
16. 
    
17. select  * from role_sys_privs rsp where rsp.role='DBA';
    
18. 
    
19. select  * from role_tab_privs rtp where rtp.role='DBA';
    
20. 
    
21. select  * from role_role_privs rrp where rrp.role='DBA';
    
22. 
    
23. select  * from dba_sys_privs sp where sp.grantee='HR';
    
24. 
    
25. select  * from dba_tab_privs tp where tp.grantee='HR';
    
26. 
    
27. select  * from dba_role_privs rp where rp.grantee='HR';
    
28. 
    
29. grant select_catalog_role to hr;
    
30. 
    
31. revoke  select_catalog_role  from hr;
    
32. 
    
33. select  * from role_sys_privs rsp where rsp.role='CONNECT';
    
34. 
    
35. select  * from role_tab_privs rtp where rtp.role='CONNECT';
    
36. 
    
37. select  * from role_role_privs rrp where rrp.role='CONNECT';
    
38. 
    
39. select * from dba_users  order by username;
    
40. 
    
41. grant connect  to u1 identified by  oracle_4U;
    
42. 
    
43. grant create session  to u2 identified by  oracle_4U;
    
44. 
    
45. create user u3 identified by u3 ;
    
46. grant connect to u3;
    
47. 
    
48. select  * from dba_sys_privs sp where sp.grantee='U1';
    
49. 
    
50. select  * from dba_tab_privs tp where tp.grantee='U1';
    
51. 
    
52. select  * from dba_role_privs rp where rp.grantee='U1';
    
53. 
    
54. select   distinct  sp.privilege  from dba_sys_privs sp  order by 1;
    
55. 
    
56. grant create table to u1;
    
57. 
    
58. select  * from dba_segments s where s.owner='U1' and s.segment_name='T05208_A';
    
59. 
    
60. select  * from dba_ts_quotas ;
    
61. 
    
62. alter user u1 quota 64k on  users;
    
63. 
    
64. alter user u1 quota 0 on  users;

复制代码

2015-08-19b.sql：

1. select  * from dba_sys_privs sp where sp.grantee='U1';
   
2. 
   
3. select  * from dba_tab_privs tp where tp.grantee='U1';
   
4. 
   
5. select  * from dba_role_privs rp where rp.grantee='U1';
   
6. 
   
7. select  * from role_sys_privs rsp where rsp.role='RESOURCE';
   
8. 
   
9. select  * from role_tab_privs rtp where rtp.role='RESOURCE';
   
10. 
    
11. select  * from role_role_privs rrp where rrp.role='RESOURCE';
    
12. 
    
13. grant resource to u1;
    
14. 
    
15. revoke resource  from u1;
    
16. 
    
17. 
    
18. select * from dba_users where username='U1';
    
19. 
    
20. 
    
21. alter user u1 account lock;
    
22. 
    
23. alter user u1 account unlock;
    
24. 
    
25. alter user u1 password expire;
    
26. 
    
27. grant select any table to u1;
    
28. 
    
29. grant select any table to public;
    
30. 
    
31. revoke  select any table from u1;
    
32. 
    
33. revoke select  any table from public;
    
34. 
    
35. select  * from dba_sys_privs sp where sp.grantee='U1';
    
36. 
    
37. select  * from dba_tab_privs tp where tp.grantee='U1';
    
38. 
    
39. select  * from dba_col_privs c where c.grantee='U1';
    
40. 
    
41. select  * from dba_role_privs rp where rp.grantee='U1';
    
42. 
    
43. 
    

复制代码