HRMS install procedure

psadmin角色的权限

点击(此处)折叠或打开

1. DROP ROLE PSADMIN;
   
2. 
   
3. CREATE ROLE PSADMIN NOT IDENTIFIED;
   
4. 
   
5. GRANT DROP USER TO PSADMIN WITH ADMIN OPTION;
   
6. GRANT ALTER USER TO PSADMIN WITH ADMIN OPTION;
   
7. GRANT ANALYZE ANY TO PSADMIN WITH ADMIN OPTION;
   
8. GRANT BECOME USER TO PSADMIN WITH ADMIN OPTION;
   
9. GRANT CREATE USER TO PSADMIN WITH ADMIN OPTION;
   
10. GRANT CREATE VIEW TO PSADMIN WITH ADMIN OPTION;
    
11. GRANT CREATE TABLE TO PSADMIN WITH ADMIN OPTION;
    
12. GRANT ALTER SESSION TO PSADMIN WITH ADMIN OPTION;
    
13. GRANT CREATE CLUSTER TO PSADMIN WITH ADMIN OPTION;
    
14. GRANT CREATE SESSION TO PSADMIN WITH ADMIN OPTION;
    
15. GRANT CREATE SYNONYM TO PSADMIN WITH ADMIN OPTION;
    
16. GRANT CREATE TRIGGER TO PSADMIN WITH ADMIN OPTION;
    
17. GRANT GRANT ANY ROLE TO PSADMIN WITH ADMIN OPTION;
    
18. GRANT CREATE SEQUENCE TO PSADMIN WITH ADMIN OPTION;
    
19. GRANT DROP TABLESPACE TO PSADMIN WITH ADMIN OPTION;
    
20. GRANT ALTER TABLESPACE TO PSADMIN WITH ADMIN OPTION;
    
21. GRANT CREATE PROCEDURE TO PSADMIN WITH ADMIN OPTION;
    
22. GRANT CREATE TABLESPACE TO PSADMIN WITH ADMIN OPTION;
    
23. GRANT MANAGE TABLESPACE TO PSADMIN WITH ADMIN OPTION;
    
24. GRANT DROP PUBLIC SYNONYM TO PSADMIN WITH ADMIN OPTION;
    
25. GRANT CREATE DATABASE LINK TO PSADMIN WITH ADMIN OPTION;
    
26. GRANT CREATE PUBLIC SYNONYM TO PSADMIN WITH ADMIN OPTION;
    
27. GRANT DROP ROLLBACK SEGMENT TO PSADMIN WITH ADMIN OPTION;
    
28. GRANT ALTER ROLLBACK SEGMENT TO PSADMIN WITH ADMIN OPTION;
    
29. GRANT CREATE ROLLBACK SEGMENT TO PSADMIN WITH ADMIN OPTION;
    
30. GRANT CREATE MATERIALIZED VIEW TO PSADMIN WITH ADMIN OPTION;
    
31. GRANT DROP PUBLIC DATABASE LINK TO PSADMIN WITH ADMIN OPTION;
    
32. GRANT CREATE PUBLIC DATABASE LINK TO PSADMIN WITH ADMIN OPTION;
    
33. GRANT RESOURCE TO PSADMIN WITH ADMIN OPTION;
    
34. GRANT EXP_FULL_DATABASE TO PSADMIN WITH ADMIN OPTION;
    
35. GRANT IMP_FULL_DATABASE TO PSADMIN WITH ADMIN OPTION;
    
36. GRANT PSADMIN TO SYSADM;
    
37. GRANT PSADMIN TO SYSTEM WITH ADMIN OPTION;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23757700/viewspace-1066930/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23757700/viewspace-1066930/