[Oracle] 시스템 권한 목록

 Oracle DB에서 사용자에게 시스템 권한을 부여할 때가 있다.

이번 게시글은 이러한 시스템 권한을 부여할 때 어떤 종류의 시스템 권한이 있는지에 대해 작성한다.

 

・시스템 권한이란?

먼저, 시스템 권한은 사용자가 데이터베이스를 조작하기 위한 권한을 의미한다.

 

・시스템 권한 목록

종류	명령어
데이터베이스(DATABASE)	ALTER DATABASE
	ALTER SYSTEM
	AUDIT SYSTEM
클러스터(CLUSTER)	CREATE CLUSTER
	CREATE ANY CLUSTER
	ALTER CLUSTER
	DROP ANY CLUSTER
컨텍스트(CONTEXT)	CREATE ANY CONTEXT
	DROP ANY CONTEXT
테이블스페이스(TABLESPACE)	CREATE TABLESPACE
	ALTER TABLESPACE
	DROP TABLESPACE
	MANAGE TABLESPACE
	UNLIMITED TABLESPACE
테이블(TABLE)	CREATE TABLE
	CREATE ANY TABLE
	ALTER TABLE
	ALTER ANY TABLE
	BACKUP ANY TABLE
	DELETE ANY TABLE
	INSERT ANY TABLE
	LOCK ANY TABLE
	SELECT ANY TABLE
	FALSHBACK ANY TABLE
	UPDATE ANY TABLE
형(TYPE)	CREATE TYPE
	CREATE ANY TYPE
	ALTER ANY TYPE
	DROP ANY TYPE
	EXECUTE AMU TYPE
	UNDER ANY TYPE
인덱스(INDEX)	CREATE ANY INDEX
	ALTER ANY INDEX
	DROP ANY INDEX
	QUERY REWRITE
	GLOBAL QUERY REWRITE
	CREATE LIBRARY
	CREATE ANY LIBRARY
	DROP ANY LIBRARY
인덱스타입(INDEXTYPE)	CREATE INDEXTYPE
	CREATE ANY INDEXTYPE
	ALTER ANY INDEXTYPE
	DROP ANY INDEXTYPE
	EXECUTE ANY INDEXTYPE
뷰(VIEW)	CREATE VIEW
	CREATE ANY VIEW
	DROP ANY VIEW
	UNDER ANY VIEW
	FLASHBACK ANY TABLE
머트리얼라이즈뷰 (MATERIALIZED)	CREATE ANY MATERIALIZED VIEW
	ALTER ANY MATERIALIZED VIEW
	DROP ANY MATERIALIZED VIEW
	QUERY REWRITE
	GLOBAL QUERY REWRITE
	ON COMMIT REFRESH
	FLASHBACK ANY TABLE
시퀀스(SEQUENCE)	CREATE SEQUENCE
	CREATE ANY SEQUENCE
	ALTER ANY SEQUENCE
	DROP ANY SEQUEMCE
	SELECT ANY SEQUENCE
디렉토리(DIRECTORY)	CREATE ANY DIRECTORY
	DROP ANY DIRECTORY
디멘션(DIMENSION)	CREATE DIMENSION
	CREATE ANY DIMENSION
	ALTER ANY DIMENSION
	DROP ANY DIMENSION
연산자(OPERATOR)	CREATE OPERATOR
	CREATE ANY OPERATOR
	DPOR ANY OPERATOR
	EXECUTE ANY OPERATOR
아웃라인(OUTLINE)	CREATE ANY OUTLINE
	ALTER ANY OUTLINE
	SELECT ANY OUTLINE
트리거(TRIGGER)	CREATE TRIGGER
	CREATE ANY TRIGGER
	ALTER ANY TRIGGER
	DROP ANY TRIGGER
	ADMINISTER DATABASE TRIGGER
시노님(SYNONYM)	CREATE SYNONYM
	CREATE ANY SYNONYM
	CREATE PUBLIC SYNONYM
	DROP ANY SYNONYM
	DROP PUBLIC SYNONYM
데이터베이스 링크 (DATABASE LINK)	CREATE DATABASE LINK
	CREATE PUBLIC DATABASE LINK
	DROP PULIB DATABASE LINK
롤백 세그먼트 (ROLLBACK SEGMENT)	CREATE ROLLBACK SEGMENT
	ALTER ROLLBACK SEGMENT
	DROP ROLLBACK SEGMENT
유저(USER)	CREATE USER
	ALTER USER
	DROP USER
	BECOME USER
프로필(PROFILE)	CREATE PROFILE
	ALTER PROFILE
	DRIP PROFILE
롤(ROLE)	CREATE ROLE
	ALTER ANY ROLE
	DROP ANY ROLE
	GRANT ANY ROLE
세션(SESSION)	CREATE SESSION
	ALTER RESOURCE COST
	ALTER SESSION
	RESTRICTED SESSION
기타(etc)	AUDIT ANY
	ANALYZE ANY
	COMMENT ANY TABLE
	EXEMPT ACCESS POLICY
	FORCE ANY TRANSACTION
	GRANT ANY OBJECT PRIVILEGE
	RESUMABLE
	SELECT ANY DICTIONARY
	SYSDBA
	SYSOPER