psadmin角色的权限

点击(此处)折叠或打开

DROP ROLE PSADMIN;
CREATE ROLE PSADMIN NOT IDENTIFIED;
GRANT DROP USER TO PSADMIN WITH ADMIN OPTION;
GRANT ALTER USER TO PSADMIN WITH ADMIN OPTION;
GRANT ANALYZE ANY TO PSADMIN WITH ADMIN OPTION;
GRANT BECOME USER TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE USER TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE VIEW TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE TABLE TO PSADMIN WITH ADMIN OPTION;
GRANT ALTER SESSION TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE CLUSTER TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE SESSION TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE SYNONYM TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO PSADMIN WITH ADMIN OPTION;
GRANT GRANT ANY ROLE TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE SEQUENCE TO PSADMIN WITH ADMIN OPTION;
GRANT DROP TABLESPACE TO PSADMIN WITH ADMIN OPTION;
GRANT ALTER TABLESPACE TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE PROCEDURE TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE TABLESPACE TO PSADMIN WITH ADMIN OPTION;
GRANT MANAGE TABLESPACE TO PSADMIN WITH ADMIN OPTION;
GRANT DROP PUBLIC SYNONYM TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE DATABASE LINK TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE PUBLIC SYNONYM TO PSADMIN WITH ADMIN OPTION;
GRANT DROP ROLLBACK SEGMENT TO PSADMIN WITH ADMIN OPTION;
GRANT ALTER ROLLBACK SEGMENT TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE ROLLBACK SEGMENT TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE MATERIALIZED VIEW TO PSADMIN WITH ADMIN OPTION;
GRANT DROP PUBLIC DATABASE LINK TO PSADMIN WITH ADMIN OPTION;
GRANT CREATE PUBLIC DATABASE LINK TO PSADMIN WITH ADMIN OPTION;
GRANT RESOURCE TO PSADMIN WITH ADMIN OPTION;
GRANT EXP_FULL_DATABASE TO PSADMIN WITH ADMIN OPTION;
GRANT IMP_FULL_DATABASE TO PSADMIN WITH ADMIN OPTION;
GRANT PSADMIN TO SYSADM;
GRANT PSADMIN TO SYSTEM WITH ADMIN OPTION;

ITPub博客

HRMS install procedure

最新文章