课程第16次

1. select  * from dba_users u order by u.username;
   
2. 
   
3. grant connect to user2 identified by oracle_4U;
   
4. 
   
5. create user ops$oracle identified externally;
   
6. 
   
7. grant create session to ops$oracle;
   
8. 
   
9. select * from role_sys_privs  sp where sp.role='RESOURCE';
   
10. 
    
11. select * from Role_Tab_Privs  tp  where tp.role='RESOURCE';
    
12. 
    
13. select * from role_role_privs  rp where rp.role='RESOURCE';

复制代码

1. select  * from dba_roles
   
2. 
   
3. create role role1;
   
4. 
   
5. grant select  on hr.employees to role1;
   
6. 
   
7. grant role1 to user2 with admin option;
   
8. 
   
9. 
   
10. select  * from dba_role_privs rp where rp.grantee='USER2';
    
11. 
    
12. revoke role1 from user2;
    
13. 
    
14. 
    
15. revoke select  on hr.employees   from role1;
    
16. 
    
17. 
    
18. grant select on hr.employees to role1;
    
19. 
    
20. 
    
21. select  * from dba_role_privs rp where rp.grantee='OPS$ORACLE';
    
22. 
    
23. 
    
24. alter user ops$oracle  default role none;
    
25. 
    
26. 
    
27. revoke role1 from ops$oracle;
    
28. 
    
29. create role role2 identified by oracle_4U;
    
30. 
    
31. 
    
32. grant role1 to role2;
    
33. 
    
34. 
    
35. grant role2 to ops$oracle;

复制代码

1. grant select_catalog_role to hr;

复制代码

--------------------------




-------------------------

1. select  * from dba_users u where u.username='USER1';
   
2. 
   
3. alter user user1 account unlock;
   
4. 
   
5. alter user user1 password expire;
   
6. 
   
7. CREATE PROFILE "PROFILE1" LIMIT
   
8. PASSWORD_LOCK_TIME .0006
   
9. FAILED_LOGIN_ATTEMPTS 1;
   
10. 
    
11. 
    
12. alter user user1 profile profile1;
    
13. 
    
14. ALTER PROFILE "PROFILE1" LIMIT PASSWORD_LIFE_TIME .0006
    
15. PASSWORD_GRACE_TIME .0006
    
16. PASSWORD_LOCK_TIME DEFAULT
    
17. FAILED_LOGIN_ATTEMPTS DEFAULT;
    
18. 
    
19. 
    
20. alter profile profile1  limit
    
21. PASSWORD_REUSE_TIME .006
    
22. PASSWORD_REUSE_MAX 1;
    

复制代码