oracle配置角色语句
GRANT ALTER ANY INDEX TO "TEST" ;
GRANT ALTER ANY MATERIALIZED VIEW TO "TEST" ;
GRANT ALTER ANY PROCEDURE TO "TEST" ;
GRANT ALTER ANY SEQUENCE TO "TEST" ;
GRANT ALTER ANY TABLE TO "TEST" ;
GRANT ALTER ANY TRIGGER TO "TEST" ;
GRANT ALTER DATABASE TO "TEST" ;
GRANT ALTER SESSION TO "TEST" ;
GRANT ALTER TABLESPACE TO "TEST" ;
GRANT ALTER USER TO "TEST" ;
GRANT COMMENT ANY TABLE TO "TEST" ;
GRANT CREATE ANY INDEX TO "TEST" ;
GRANT CREATE ANY MATERIALIZED VIEW TO "TEST" ;
GRANT CREATE ANY PROCEDURE TO "TEST" ;
GRANT CREATE ANY SEQUENCE TO "TEST" ;
GRANT CREATE ANY TABLE TO "TEST" ;
GRANT CREATE ANY TRIGGER TO "TEST" ;
GRANT CREATE ANY VIEW TO "TEST" ;
GRANT CREATE DATABASE LINK TO "TEST" ;
GRANT CREATE MATERIALIZED VIEW TO "TEST" ;
GRANT CREATE PROCEDURE TO "TEST" ;
GRANT CREATE PUBLIC DATABASE LINK TO "TEST" ;
GRANT CREATE SEQUENCE TO "TEST" ;
GRANT CREATE SESSION TO "TEST" ;
GRANT CREATE TABLE TO "TEST" ;
GRANT CREATE TABLESPACE TO "TEST" ;
GRANT CREATE TRIGGER TO "TEST" ;
GRANT CREATE USER TO "TEST" ;
GRANT CREATE VIEW TO "TEST" ;
GRANT DEBUG ANY PROCEDURE TO "TEST" ;
GRANT DELETE ANY TABLE TO "TEST" ;
GRANT DROP ANY INDEX TO "TEST" ;
GRANT DROP ANY MATERIALIZED VIEW TO "TEST" ;
GRANT DROP ANY PROCEDURE TO "TEST" ;
GRANT DROP ANY SEQUENCE TO "TEST" ;
GRANT DROP ANY TABLE TO "TEST" ;
GRANT DROP ANY TRIGGER TO "TEST" ;
GRANT DROP ANY VIEW TO "TEST" ;
GRANT DROP PUBLIC DATABASE LINK TO "TEST" ;
GRANT DROP TABLESPACE TO "TEST" ;
GRANT DROP USER TO "TEST" ;
GRANT EXECUTE ANY PROCEDURE TO "TEST" ;
GRANT EXPORT FULL DATABASE TO "TEST" ;
GRANT GRANT ANY PRIVILEGE TO "TEST" ;
GRANT IMPORT FULL DATABASE TO "TEST" ;
GRANT INSERT ANY TABLE TO "TEST" ;
GRANT MANAGE TABLESPACE TO "TEST" ;
GRANT MERGE ANY VIEW TO "TEST" ;
GRANT SELECT ANY SEQUENCE TO "TEST" ;
GRANT SELECT ANY TABLE TO "TEST" ;
GRANT SYSDBA TO "TEST" ;
GRANT UNLIMITED TABLESPACE TO "TEST" ;
GRANT UPDATE ANY TABLE TO "TEST" ;
GRANT "CONNECT" TO "TEST" ;
GRANT "DBA" TO "TEST" ;