행위

"오라클 DBA 시스템 권한"의 두 판 사이의 차이

DB CAFE
258번째 줄: 258번째 줄:
 
USE ANY SQL TRANSLATION PROFILE
 
USE ANY SQL TRANSLATION PROFILE
 
</source>
 
</source>
 +
 +
=== DBA 권한에서 빠지는 SYSDBA 권한 ==
 +
<source lang=sql>
 +
grant ADMINISTER ANY SQL TUNING SET to migcommon;
 +
grant ADMINISTER DATABASE TRIGGER to migcommon;
 +
grant ADMINISTER SQL MANAGEMENT OBJECT to migcommon;
 +
grant ADMINISTER SQL TUNING SET to migcommon;
 +
grant ADVISOR to migcommon;
 +
grant ALTER ANY ASSEMBLY to migcommon;
 +
grant ALTER ANY CLUSTER to migcommon;
 +
grant ALTER ANY CUBE to migcommon;
 +
grant ALTER ANY CUBE DIMENSION to migcommon;
 +
grant ALTER ANY DIMENSION to migcommon;
 +
grant ALTER ANY EDITION to migcommon;
 +
grant ALTER ANY INDEX to migcommon;
 +
grant ALTER ANY INDEXTYPE to migcommon;
 +
grant ALTER ANY LIBRARY to migcommon;
 +
grant ALTER ANY MATERIALIZED VIEW to migcommon;
 +
grant ALTER ANY MINING MODEL to migcommon;
 +
grant ALTER ANY OPERATOR to migcommon;
 +
grant ALTER ANY OUTLINE to migcommon;
 +
grant ALTER ANY PROCEDURE to migcommon;
 +
grant ALTER ANY ROLE to migcommon;
 +
grant ALTER ANY SEQUENCE to migcommon;
 +
grant ALTER ANY SQL PROFILE to migcommon;
 +
grant ALTER ANY TABLE to migcommon;
 +
grant ALTER ANY TRIGGER to migcommon;
 +
grant ALTER ANY TYPE to migcommon;
 +
grant ALTER DATABASE to migcommon;
 +
grant ALTER DATABASE LINK to migcommon;
 +
grant ALTER PROFILE to migcommon;
 +
grant ALTER PUBLIC DATABASE LINK to migcommon;
 +
grant ALTER RESOURCE COST to migcommon;
 +
grant ALTER ROLLBACK SEGMENT to migcommon;
 +
grant ALTER SESSION to migcommon;
 +
grant ALTER SYSTEM to migcommon;
 +
grant ALTER TABLESPACE to migcommon;
 +
grant ALTER USER to migcommon;
 +
grant ANALYZE ANY to migcommon;
 +
grant ANALYZE ANY DICTIONARY to migcommon;
 +
grant AUDIT ANY to migcommon;
 +
grant AUDIT SYSTEM to migcommon;
 +
grant BACKUP ANY TABLE to migcommon;
 +
grant BECOME USER to migcommon;
 +
grant CHANGE NOTIFICATION to migcommon;
 +
grant COMMENT ANY MINING MODEL to migcommon;
 +
grant COMMENT ANY TABLE to migcommon;
 +
grant CREATE ANY ASSEMBLY to migcommon;
 +
grant CREATE ANY CLUSTER to migcommon;
 +
grant CREATE ANY CONTEXT to migcommon;
 +
grant CREATE ANY CUBE to migcommon;
 +
grant CREATE ANY CUBE BUILD PROCESS to migcommon;
 +
grant CREATE ANY CUBE DIMENSION to migcommon;
 +
grant CREATE ANY DIMENSION to migcommon;
 +
grant CREATE ANY DIRECTORY to migcommon;
 +
grant CREATE ANY EDITION to migcommon;
 +
grant CREATE ANY INDEX to migcommon;
 +
grant CREATE ANY INDEXTYPE to migcommon;
 +
grant CREATE ANY JOB to migcommon;
 +
grant CREATE ANY LIBRARY to migcommon;
 +
grant CREATE ANY MATERIALIZED VIEW to migcommon;
 +
grant CREATE ANY MEASURE FOLDER to migcommon;
 +
grant CREATE ANY MINING MODEL to migcommon;
 +
grant CREATE ANY OPERATOR to migcommon;
 +
grant CREATE ANY OUTLINE to migcommon;
 +
grant CREATE ANY PROCEDURE to migcommon;
 +
grant CREATE ANY SEQUENCE to migcommon;
 +
grant CREATE ANY SQL PROFILE to migcommon;
 +
grant CREATE ANY SYNONYM to migcommon;
 +
grant CREATE ANY TABLE to migcommon;
 +
grant CREATE ANY TRIGGER to migcommon;
 +
grant CREATE ANY TYPE to migcommon;
 +
grant CREATE ANY VIEW to migcommon;
 +
grant CREATE ASSEMBLY to migcommon;
 +
grant CREATE CLUSTER to migcommon;
 +
grant CREATE CUBE to migcommon;
 +
grant CREATE CUBE BUILD PROCESS to migcommon;
 +
grant CREATE CUBE DIMENSION to migcommon;
 +
grant CREATE DATABASE LINK to migcommon;
 +
grant CREATE DIMENSION to migcommon;
 +
grant CREATE EXTERNAL JOB to migcommon;
 +
grant CREATE INDEXTYPE to migcommon;
 +
grant CREATE JOB to migcommon;
 +
grant CREATE LIBRARY to migcommon;
 +
grant CREATE MATERIALIZED VIEW to migcommon;
 +
grant CREATE MEASURE FOLDER to migcommon;
 +
grant CREATE MINING MODEL to migcommon;
 +
grant CREATE OPERATOR to migcommon;
 +
grant CREATE PROCEDURE to migcommon;
 +
grant CREATE PROFILE to migcommon;
 +
grant CREATE PUBLIC DATABASE LINK to migcommon;
 +
grant CREATE PUBLIC SYNONYM to migcommon;
 +
grant CREATE ROLE to migcommon;
 +
grant CREATE ROLLBACK SEGMENT to migcommon;
 +
grant CREATE SEQUENCE to migcommon;
 +
grant CREATE SESSION to migcommon;
 +
grant CREATE SYNONYM to migcommon;
 +
grant CREATE TABLE to migcommon;
 +
grant CREATE TABLESPACE to migcommon;
 +
grant CREATE TRIGGER to migcommon;
 +
grant CREATE TYPE to migcommon;
 +
grant CREATE USER to migcommon;
 +
grant CREATE VIEW to migcommon;
 +
grant DEBUG ANY PROCEDURE to migcommon;
 +
grant DEBUG CONNECT SESSION to migcommon;
 +
grant DELETE ANY CUBE DIMENSION to migcommon;
 +
grant DELETE ANY MEASURE FOLDER to migcommon;
 +
grant DELETE ANY TABLE to migcommon;
 +
grant DROP ANY ASSEMBLY to migcommon;
 +
grant DROP ANY CLUSTER to migcommon;
 +
grant DROP ANY CONTEXT to migcommon;
 +
grant DROP ANY CUBE to migcommon;
 +
grant DROP ANY CUBE BUILD PROCESS to migcommon;
 +
grant DROP ANY CUBE DIMENSION to migcommon;
 +
grant DROP ANY DIMENSION to migcommon;
 +
grant DROP ANY DIRECTORY to migcommon;
 +
grant DROP ANY EDITION to migcommon;
 +
grant DROP ANY INDEX to migcommon;
 +
grant DROP ANY INDEXTYPE to migcommon;
 +
grant DROP ANY LIBRARY to migcommon;
 +
grant DROP ANY MATERIALIZED VIEW to migcommon;
 +
grant DROP ANY MEASURE FOLDER to migcommon;
 +
grant DROP ANY MINING MODEL to migcommon;
 +
grant DROP ANY OPERATOR to migcommon;
 +
grant DROP ANY OUTLINE to migcommon;
 +
grant DROP ANY PROCEDURE to migcommon;
 +
grant DROP ANY ROLE to migcommon;
 +
grant DROP ANY SEQUENCE to migcommon;
 +
grant DROP ANY SQL PROFILE to migcommon;
 +
grant DROP ANY SYNONYM to migcommon;
 +
grant DROP ANY TABLE to migcommon;
 +
grant DROP ANY TRIGGER to migcommon;
 +
grant DROP ANY TYPE to migcommon;
 +
grant DROP ANY VIEW to migcommon;
 +
grant DROP PROFILE to migcommon;
 +
grant DROP PUBLIC DATABASE LINK to migcommon;
 +
grant DROP PUBLIC SYNONYM to migcommon;
 +
grant DROP ROLLBACK SEGMENT to migcommon;
 +
grant DROP TABLESPACE to migcommon;
 +
grant DROP USER to migcommon;
 +
grant EXECUTE ANY ASSEMBLY to migcommon;
 +
grant EXECUTE ANY CLASS to migcommon;
 +
grant EXECUTE ANY INDEXTYPE to migcommon;
 +
grant EXECUTE ANY LIBRARY to migcommon;
 +
grant EXECUTE ANY OPERATOR to migcommon;
 +
grant EXECUTE ANY PROCEDURE to migcommon;
 +
grant EXECUTE ANY PROGRAM to migcommon;
 +
grant EXECUTE ANY TYPE to migcommon;
 +
grant EXECUTE ASSEMBLY to migcommon;
 +
grant EXEMPT ACCESS POLICY to migcommon;
 +
grant EXEMPT IDENTITY POLICY to migcommon;
 +
grant EXPORT FULL DATABASE to migcommon;
 +
grant FLASHBACK ANY TABLE to migcommon;
 +
grant FLASHBACK ARCHIVE ADMINISTER to migcommon;
 +
grant FORCE ANY TRANSACTION to migcommon;
 +
grant FORCE TRANSACTION to migcommon;
 +
grant GLOBAL QUERY REWRITE to migcommon;
 +
grant GRANT ANY OBJECT PRIVILEGE to migcommon;
 +
grant GRANT ANY PRIVILEGE to migcommon;
 +
grant GRANT ANY ROLE to migcommon;
 +
grant IMPORT FULL DATABASE to migcommon;
 +
grant INSERT ANY CUBE DIMENSION to migcommon;
 +
grant INSERT ANY MEASURE FOLDER to migcommon;
 +
grant INSERT ANY TABLE to migcommon;
 +
grant LOCK ANY TABLE to migcommon;
 +
grant MANAGE SCHEDULER to migcommon;
 +
grant MANAGE TABLESPACE to migcommon;
 +
grant MERGE ANY VIEW to migcommon;
 +
grant ON COMMIT REFRESH to migcommon;
 +
grant QUERY REWRITE to migcommon;
 +
grant RESTRICTED SESSION to migcommon;
 +
grant RESUMABLE to migcommon;
 +
grant SELECT ANY CUBE to migcommon;
 +
grant SELECT ANY CUBE DIMENSION to migcommon;
 +
grant SELECT ANY DICTIONARY to migcommon;
 +
grant SELECT ANY MINING MODEL to migcommon;
 +
grant SELECT ANY SEQUENCE to migcommon;
 +
grant SELECT ANY TABLE to migcommon;
 +
grant SELECT ANY TRANSACTION to migcommon;
 +
grant UNDER ANY TABLE to migcommon;
 +
grant UNDER ANY TYPE to migcommon;
 +
grant UNDER ANY VIEW to migcommon;
 +
grant UNLIMITED TABLESPACE to migcommon;
 +
grant UPDATE ANY CUBE to migcommon;
 +
grant UPDATE ANY CUBE BUILD PROCESS to migcommon;
 +
grant UPDATE ANY CUBE DIMENSION to migcommon;
 +
grant UPDATE ANY TABLE to migcommon;
 +
</source>
 +
 
[[category:oracle]]
 
[[category:oracle]]

2020년 10월 29일 (목) 10:40 판

thumb_up 추천메뉴 바로가기

1 DBA System 권한[편집]

ADMINISTER ANY SQL TUNING SET
ADMINISTER DATABASE TRIGGER
ADMINISTER KEY MANAGEMENT
ADMINISTER RESOURCE MANAGER
ADMINISTER SQL MANAGEMENT OBJECT
ADMINISTER SQL TUNING SET
ADVISOR
ALTER ANY ANALYTIC VIEW
ALTER ANY ASSEMBLY
ALTER ANY ATTRIBUTE DIMENSION
ALTER ANY CLUSTER
ALTER ANY CUBE
ALTER ANY CUBE BUILD PROCESS
ALTER ANY CUBE DIMENSION
ALTER ANY DIMENSION
ALTER ANY EDITION
ALTER ANY EVALUATION CONTEXT
ALTER ANY HIERARCHY
ALTER ANY INDEX
ALTER ANY INDEXTYPE
ALTER ANY LIBRARY
ALTER ANY MATERIALIZED VIEW
ALTER ANY MEASURE FOLDER
ALTER ANY MINING MODEL
ALTER ANY OPERATOR
ALTER ANY OUTLINE
ALTER ANY PROCEDURE
ALTER ANY ROLE
ALTER ANY RULE
ALTER ANY RULE SET
ALTER ANY SEQUENCE
ALTER ANY SQL PROFILE
ALTER ANY SQL TRANSLATION PROFILE
ALTER ANY TABLE
ALTER ANY TRIGGER
ALTER ANY TYPE
ALTER DATABASE
ALTER DATABASE LINK
ALTER LOCKDOWN PROFILE
ALTER PROFILE
ALTER PUBLIC DATABASE LINK
ALTER RESOURCE COST
ALTER ROLLBACK SEGMENT
ALTER SESSION
ALTER SYSTEM
ALTER TABLESPACE
ALTER USER
ANALYZE ANY
ANALYZE ANY DICTIONARY
AUDIT ANY
AUDIT SYSTEM
BACKUP ANY TABLE
BECOME USER
CHANGE NOTIFICATION
COMMENT ANY MINING MODEL
COMMENT ANY TABLE
CREATE ANALYTIC VIEW
CREATE ANY ANALYTIC VIEW
CREATE ANY ASSEMBLY
CREATE ANY ATTRIBUTE DIMENSION
CREATE ANY CLUSTER
CREATE ANY CONTEXT
CREATE ANY CREDENTIAL
CREATE ANY CUBE
CREATE ANY CUBE BUILD PROCESS
CREATE ANY CUBE DIMENSION
CREATE ANY DIMENSION
CREATE ANY DIRECTORY
CREATE ANY EDITION
CREATE ANY EVALUATION CONTEXT
CREATE ANY HIERARCHY
CREATE ANY INDEX
CREATE ANY INDEXTYPE
CREATE ANY JOB
CREATE ANY LIBRARY
CREATE ANY MATERIALIZED VIEW
CREATE ANY MEASURE FOLDER
CREATE ANY MINING MODEL
CREATE ANY OPERATOR
CREATE ANY OUTLINE
CREATE ANY PROCEDURE
CREATE ANY RULE
CREATE ANY RULE SET
CREATE ANY SEQUENCE
CREATE ANY SQL PROFILE
CREATE ANY SQL TRANSLATION PROFILE
CREATE ANY SYNONYM
CREATE ANY TABLE
CREATE ANY TRIGGER
CREATE ANY TYPE
CREATE ANY VIEW
CREATE ASSEMBLY
CREATE ATTRIBUTE DIMENSION
CREATE CLUSTER
CREATE CREDENTIAL
CREATE CUBE
CREATE CUBE BUILD PROCESS
CREATE CUBE DIMENSION
CREATE DATABASE LINK
CREATE DIMENSION
CREATE EVALUATION CONTEXT
CREATE EXTERNAL JOB
CREATE HIERARCHY
CREATE INDEXTYPE
CREATE JOB
CREATE LIBRARY
CREATE LOCKDOWN PROFILE
CREATE MATERIALIZED VIEW
CREATE MEASURE FOLDER
CREATE MINING MODEL
CREATE OPERATOR
CREATE PLUGGABLE DATABASE
CREATE PROCEDURE
CREATE PROFILE
CREATE PUBLIC DATABASE LINK
CREATE PUBLIC SYNONYM
CREATE ROLE
CREATE ROLLBACK SEGMENT
CREATE RULE
CREATE RULE SET
CREATE SEQUENCE
CREATE SESSION
CREATE SQL TRANSLATION PROFILE
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
DEBUG ANY PROCEDURE
DEBUG CONNECT ANY
DEBUG CONNECT SESSION
DELETE ANY CUBE DIMENSION
DELETE ANY MEASURE FOLDER
DELETE ANY TABLE
DEQUEUE ANY QUEUE
DROP ANY ANALYTIC VIEW
DROP ANY ASSEMBLY
DROP ANY ATTRIBUTE DIMENSION
DROP ANY CLUSTER
DROP ANY CONTEXT
DROP ANY CUBE
DROP ANY CUBE BUILD PROCESS
DROP ANY CUBE DIMENSION
DROP ANY DIMENSION
DROP ANY DIRECTORY
DROP ANY EDITION
DROP ANY EVALUATION CONTEXT
DROP ANY HIERARCHY
DROP ANY INDEX
DROP ANY INDEXTYPE
DROP ANY LIBRARY
DROP ANY MATERIALIZED VIEW
DROP ANY MEASURE FOLDER
DROP ANY MINING MODEL
DROP ANY OPERATOR
DROP ANY OUTLINE
DROP ANY PROCEDURE
DROP ANY ROLE
DROP ANY RULE
DROP ANY RULE SET
DROP ANY SEQUENCE
DROP ANY SQL PROFILE
DROP ANY SQL TRANSLATION PROFILE
DROP ANY SYNONYM
DROP ANY TABLE
DROP ANY TRIGGER
DROP ANY TYPE
DROP ANY VIEW
DROP LOCKDOWN PROFILE
DROP PROFILE
DROP PUBLIC DATABASE LINK
DROP PUBLIC SYNONYM
DROP ROLLBACK SEGMENT
DROP TABLESPACE
DROP USER
EM EXPRESS CONNECT
ENQUEUE ANY QUEUE
EXECUTE ANY ASSEMBLY
EXECUTE ANY CLASS
EXECUTE ANY EVALUATION CONTEXT
EXECUTE ANY INDEXTYPE
EXECUTE ANY LIBRARY
EXECUTE ANY OPERATOR
EXECUTE ANY PROCEDURE
EXECUTE ANY PROGRAM
EXECUTE ANY RULE
EXECUTE ANY RULE SET
EXECUTE ANY TYPE
EXECUTE ASSEMBLY
EXEMPT ACCESS POLICY
EXEMPT DDL REDACTION POLICY
EXEMPT DML REDACTION POLICY
EXEMPT IDENTITY POLICY
EXEMPT REDACTION POLICY
EXPORT FULL DATABASE
FLASHBACK ANY TABLE
FLASHBACK ARCHIVE ADMINISTER
FORCE ANY TRANSACTION
FORCE TRANSACTION
GLOBAL QUERY REWRITE
GRANT ANY OBJECT PRIVILEGE
GRANT ANY PRIVILEGE
GRANT ANY ROLE
IMPORT FULL DATABASE
INHERIT ANY PRIVILEGES
INHERIT ANY REMOTE PRIVILEGES
INSERT ANY CUBE DIMENSION
INSERT ANY MEASURE FOLDER
INSERT ANY TABLE
KEEP DATE TIME
KEEP SYSGUID
LOCK ANY TABLE
LOGMINING
MANAGE ANY FILE GROUP
MANAGE ANY QUEUE
MANAGE FILE GROUP
MANAGE SCHEDULER
MANAGE TABLESPACE
MERGE ANY VIEW
ON COMMIT REFRESH
PURGE DBA_RECYCLEBIN
QUERY REWRITE
READ ANY FILE GROUP
READ ANY TABLE
REDEFINE ANY TABLE
RESTRICTED SESSION
RESUMABLE
SELECT ANY CUBE
SELECT ANY CUBE BUILD PROCESS
SELECT ANY CUBE DIMENSION
SELECT ANY DICTIONARY
SELECT ANY MEASURE FOLDER
SELECT ANY MINING MODEL
SELECT ANY SEQUENCE
SELECT ANY TABLE
SELECT ANY TRANSACTION
SET CONTAINER
SYSBACKUP
SYSDBA
SYSDG
SYSKM
SYSOPER
SYSRAC
TRANSLATE ANY SQL
UNDER ANY TABLE
UNDER ANY TYPE
UNDER ANY VIEW
UNLIMITED TABLESPACE
UPDATE ANY CUBE
UPDATE ANY CUBE BUILD PROCESS
UPDATE ANY CUBE DIMENSION
UPDATE ANY TABLE
USE ANY JOB RESOURCE
USE ANY SQL TRANSLATION PROFILE

2 = DBA 권한에서 빠지는 SYSDBA 권한[편집]

grant ADMINISTER ANY SQL TUNING SET	to migcommon;
grant ADMINISTER DATABASE TRIGGER	to migcommon;
grant ADMINISTER SQL MANAGEMENT OBJECT	to migcommon;
grant ADMINISTER SQL TUNING SET	to migcommon;
grant ADVISOR	to migcommon;
grant ALTER ANY ASSEMBLY	to migcommon;
grant ALTER ANY CLUSTER	to migcommon;
grant ALTER ANY CUBE	to migcommon;
grant ALTER ANY CUBE DIMENSION	to migcommon;
grant ALTER ANY DIMENSION	to migcommon;
grant ALTER ANY EDITION	to migcommon;
grant ALTER ANY INDEX	to migcommon;
grant ALTER ANY INDEXTYPE	to migcommon;
grant ALTER ANY LIBRARY	to migcommon;
grant ALTER ANY MATERIALIZED VIEW	to migcommon;
grant ALTER ANY MINING MODEL	to migcommon;
grant ALTER ANY OPERATOR	to migcommon;
grant ALTER ANY OUTLINE	to migcommon;
grant ALTER ANY PROCEDURE	to migcommon;
grant ALTER ANY ROLE	to migcommon;
grant ALTER ANY SEQUENCE	to migcommon;
grant ALTER ANY SQL PROFILE	to migcommon;
grant ALTER ANY TABLE	to migcommon;
grant ALTER ANY TRIGGER	to migcommon;
grant ALTER ANY TYPE	to migcommon;
grant ALTER DATABASE	to migcommon;
grant ALTER DATABASE LINK	to migcommon;
grant ALTER PROFILE	to migcommon;
grant ALTER PUBLIC DATABASE LINK	to migcommon;
grant ALTER RESOURCE COST	to migcommon;
grant ALTER ROLLBACK SEGMENT	to migcommon;
grant ALTER SESSION	to migcommon;
grant ALTER SYSTEM	to migcommon;
grant ALTER TABLESPACE	to migcommon;
grant ALTER USER	to migcommon;
grant ANALYZE ANY	to migcommon;
grant ANALYZE ANY DICTIONARY	to migcommon;
grant AUDIT ANY	to migcommon;
grant AUDIT SYSTEM	to migcommon;
grant BACKUP ANY TABLE	to migcommon;
grant BECOME USER	to migcommon;
grant CHANGE NOTIFICATION	to migcommon;
grant COMMENT ANY MINING MODEL	to migcommon;
grant COMMENT ANY TABLE	to migcommon;
grant CREATE ANY ASSEMBLY	to migcommon;
grant CREATE ANY CLUSTER	to migcommon;
grant CREATE ANY CONTEXT	to migcommon;
grant CREATE ANY CUBE	to migcommon;
grant CREATE ANY CUBE BUILD PROCESS	to migcommon;
grant CREATE ANY CUBE DIMENSION	to migcommon;
grant CREATE ANY DIMENSION	to migcommon;
grant CREATE ANY DIRECTORY	to migcommon;
grant CREATE ANY EDITION	to migcommon;
grant CREATE ANY INDEX	to migcommon;
grant CREATE ANY INDEXTYPE	to migcommon;
grant CREATE ANY JOB	to migcommon;
grant CREATE ANY LIBRARY	to migcommon;
grant CREATE ANY MATERIALIZED VIEW	to migcommon;
grant CREATE ANY MEASURE FOLDER	to migcommon;
grant CREATE ANY MINING MODEL	to migcommon;
grant CREATE ANY OPERATOR	to migcommon;
grant CREATE ANY OUTLINE	to migcommon;
grant CREATE ANY PROCEDURE	to migcommon;
grant CREATE ANY SEQUENCE	to migcommon;
grant CREATE ANY SQL PROFILE	to migcommon;
grant CREATE ANY SYNONYM	to migcommon;
grant CREATE ANY TABLE	to migcommon;
grant CREATE ANY TRIGGER	to migcommon;
grant CREATE ANY TYPE	to migcommon;
grant CREATE ANY VIEW	to migcommon;
grant CREATE ASSEMBLY	to migcommon;
grant CREATE CLUSTER	to migcommon;
grant CREATE CUBE	to migcommon;
grant CREATE CUBE BUILD PROCESS	to migcommon;
grant CREATE CUBE DIMENSION	to migcommon;
grant CREATE DATABASE LINK	to migcommon;
grant CREATE DIMENSION	to migcommon;
grant CREATE EXTERNAL JOB	to migcommon;
grant CREATE INDEXTYPE	to migcommon;
grant CREATE JOB	to migcommon;
grant CREATE LIBRARY	to migcommon;
grant CREATE MATERIALIZED VIEW	to migcommon;
grant CREATE MEASURE FOLDER	to migcommon;
grant CREATE MINING MODEL	to migcommon;
grant CREATE OPERATOR	to migcommon;
grant CREATE PROCEDURE	to migcommon;
grant CREATE PROFILE	to migcommon;
grant CREATE PUBLIC DATABASE LINK	to migcommon;
grant CREATE PUBLIC SYNONYM	to migcommon;
grant CREATE ROLE	to migcommon;
grant CREATE ROLLBACK SEGMENT	to migcommon;
grant CREATE SEQUENCE	to migcommon;
grant CREATE SESSION	to migcommon;
grant CREATE SYNONYM	to migcommon;
grant CREATE TABLE	to migcommon;
grant CREATE TABLESPACE	to migcommon;
grant CREATE TRIGGER	to migcommon;
grant CREATE TYPE	to migcommon;
grant CREATE USER	to migcommon;
grant CREATE VIEW	to migcommon;
grant DEBUG ANY PROCEDURE	to migcommon;
grant DEBUG CONNECT SESSION	to migcommon;
grant DELETE ANY CUBE DIMENSION	to migcommon;
grant DELETE ANY MEASURE FOLDER	to migcommon;
grant DELETE ANY TABLE	to migcommon;
grant DROP ANY ASSEMBLY	to migcommon;
grant DROP ANY CLUSTER	to migcommon;
grant DROP ANY CONTEXT	to migcommon;
grant DROP ANY CUBE	to migcommon;
grant DROP ANY CUBE BUILD PROCESS	to migcommon;
grant DROP ANY CUBE DIMENSION	to migcommon;
grant DROP ANY DIMENSION	to migcommon;
grant DROP ANY DIRECTORY	to migcommon;
grant DROP ANY EDITION	to migcommon;
grant DROP ANY INDEX	to migcommon;
grant DROP ANY INDEXTYPE	to migcommon;
grant DROP ANY LIBRARY	to migcommon;
grant DROP ANY MATERIALIZED VIEW	to migcommon;
grant DROP ANY MEASURE FOLDER	to migcommon;
grant DROP ANY MINING MODEL	to migcommon;
grant DROP ANY OPERATOR	to migcommon;
grant DROP ANY OUTLINE	to migcommon;
grant DROP ANY PROCEDURE	to migcommon;
grant DROP ANY ROLE	to migcommon;
grant DROP ANY SEQUENCE	to migcommon;
grant DROP ANY SQL PROFILE	to migcommon;
grant DROP ANY SYNONYM	to migcommon;
grant DROP ANY TABLE	to migcommon;
grant DROP ANY TRIGGER	to migcommon;
grant DROP ANY TYPE	to migcommon;
grant DROP ANY VIEW	to migcommon;
grant DROP PROFILE	to migcommon;
grant DROP PUBLIC DATABASE LINK	to migcommon;
grant DROP PUBLIC SYNONYM	to migcommon;
grant DROP ROLLBACK SEGMENT	to migcommon;
grant DROP TABLESPACE	to migcommon;
grant DROP USER	to migcommon;
grant EXECUTE ANY ASSEMBLY	to migcommon;
grant EXECUTE ANY CLASS	to migcommon;
grant EXECUTE ANY INDEXTYPE	to migcommon;
grant EXECUTE ANY LIBRARY	to migcommon;
grant EXECUTE ANY OPERATOR	to migcommon;
grant EXECUTE ANY PROCEDURE	to migcommon;
grant EXECUTE ANY PROGRAM	to migcommon;
grant EXECUTE ANY TYPE	to migcommon;
grant EXECUTE ASSEMBLY	to migcommon;
grant EXEMPT ACCESS POLICY	to migcommon;
grant EXEMPT IDENTITY POLICY	to migcommon;
grant EXPORT FULL DATABASE	to migcommon;
grant FLASHBACK ANY TABLE	to migcommon;
grant FLASHBACK ARCHIVE ADMINISTER	to migcommon;
grant FORCE ANY TRANSACTION	to migcommon;
grant FORCE TRANSACTION	to migcommon;
grant GLOBAL QUERY REWRITE	to migcommon;
grant GRANT ANY OBJECT PRIVILEGE	to migcommon;
grant GRANT ANY PRIVILEGE	to migcommon;
grant GRANT ANY ROLE	to migcommon;
grant IMPORT FULL DATABASE	to migcommon;
grant INSERT ANY CUBE DIMENSION	to migcommon;
grant INSERT ANY MEASURE FOLDER	to migcommon;
grant INSERT ANY TABLE	to migcommon;
grant LOCK ANY TABLE	to migcommon;
grant MANAGE SCHEDULER	to migcommon;
grant MANAGE TABLESPACE	to migcommon;
grant MERGE ANY VIEW	to migcommon;
grant ON COMMIT REFRESH	to migcommon;
grant QUERY REWRITE	to migcommon;
grant RESTRICTED SESSION	to migcommon;
grant RESUMABLE	to migcommon;
grant SELECT ANY CUBE	to migcommon;
grant SELECT ANY CUBE DIMENSION	to migcommon;
grant SELECT ANY DICTIONARY	to migcommon;
grant SELECT ANY MINING MODEL	to migcommon;
grant SELECT ANY SEQUENCE	to migcommon;
grant SELECT ANY TABLE	to migcommon;
grant SELECT ANY TRANSACTION	to migcommon;
grant UNDER ANY TABLE	to migcommon;
grant UNDER ANY TYPE	to migcommon;
grant UNDER ANY VIEW	to migcommon;
grant UNLIMITED TABLESPACE	to migcommon;
grant UPDATE ANY CUBE	to migcommon;
grant UPDATE ANY CUBE BUILD PROCESS	to migcommon;
grant UPDATE ANY CUBE DIMENSION	to migcommon;
grant UPDATE ANY TABLE	to migcommon;
원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=오라클_DBA_시스템_권한&oldid=4825"