システム権限一覧
システム権限の種類と各サブタイプ(オプション)一覧
GRANT [サブタイプ] {権限名} TO {ユーザー名}
例えば 権限名 CONTEXT の場合
GRANT CREATE ANY CONTEXT ... TO ...
GRANT DROP ANY CONTEXT ...
権限名 | 権限のサブタイプ(付帯するオプション) |
ADVISOR | なし |
ADMINISTER SQL TUNING SET | なし、ANY |
CLUSTER | CREATE、CREATE ANY、ALTER ANY、DROP ANY |
CONTEXT | CRAETE ANY、DROP ANY |
ALTER DATABASE | なし |
ALTER SYSTEM |
AUDIT SYSTEM |
DATABASE LINK | CREATE、 CREATE PUBLIC、DROP PUBLIC |
DEBUG | CONNECT SESSION、ANY PROCEDURE |
DIMENSION | CREATE、CREATE ANY、ALTER ANY、DROP ANY |
DIRECTORY | CREATE ANY、DROP ANY |
INDEXTYPE | CREATE、CREATE ANY、ALTER ANY、EXECUTE ANY |
INDEX | CREATE、ALTER ANY、DROP ANY |
JOB | CREATE、CREATE ANY、CREATE EXTRENAL |
├ PROGRAM | EXECUTE ANY |
├ CLASS | EXECUTE ANY |
└ MANAGE SCHEDULER | なし |
LIBRARY | CREATE、CREATE ANY、DROP ANY |
MATERIALIZED VIEW | CREATE、CRAEATE ANY、ALTER ANY、DROP ANY、(FLASH BACK ANY TABLE) |
├ QUERY REWRITE ├ 現在は使用されていない。 | なし |
├ GLOBAL QUERY REWRITE |
└ ON COMMIT REFRESH |
OPERATOR | CREATE、CREATE ANY、ALTER ANY、DROP ANY、EXECUTE ANY |
OUTLINE | CREATE ANY、ALTER ANY、DROP ANY |
PROCEDURE | CREATE、CREATE ANY、ALTER ANY、DROP ANY、EXECUTE ANY |
PROFILE | CREATE、ALTER、DROP |
PROFILE | CREATE ANY、 DROP ANY、 ALTER ANY |
ROLE | CREATE、ALTER ANY、DROP ANY、GRANT ANY |
ROLLBACK SEGMENT | CREATE、 ALTER、 DROP |
SEQUENCE | CREATE、CREATE ANY、ALTER ANY、DROP ANY、SELECT ANY |
SESSION | CREATE、ALTER、RESTRICTED |
└ RESOURCE COST | ALTER |
SYNOYM | CREATE、CREATE ANY、CREATE PUBLIC、DROP ANY、DROP PUBLIC |
TABLE | CREATE、CREATE ANY、ALTER ANY、BACKUP ANY、DELETE ANY、DROP ANY、INSERT ANY、LOCK ANY、SELECT ANY、FLASHBACK ANY、UPDATE ANY |
TABLE SPACE | CREATE、ALTER、DROP、MANAGE、UNLIMITED |
TRIGGER | CREATE、CREATE ANY、ALTER ANY、DROP ANY |
ADMINISTER DATBASE TRIGGER | なし |
TYPE | CREATE、CREATE ANY、ALTER ANY、DROP ANY、EXECUTE ANY、UNDER ANY |
USER | CREATE、ALTER、DROP |
VIEW | CREATE、CREATE ANY、DROP ANY、UNDER ANY、(FLASHBACK ANY TABLE) |
ANALYZE ANY | なし |
AUDIT ANY |
CHANGE NOTIFICATION |
COMMENT ANY TABLE |
EXEMPT ACCESS POLICY |
FORCE ANY TRANSACTION |
FORCE TRANSACTION |
GRANT ANY OBJECT PRIVILEGE |
GRANT ANY PRIVILEGE |
RESUMABLE |
SELECT ANY DICTIONARY |
SELECT ANY TRANSACTION |
SYSDBA |
SYSOPER |
CONNECT |
RESOURCE |
DBA |
CATALOG_ROLE | SELECT、DELETE、EXECUTE |
EXP_FULL_DATABASE | なし |
IMP_FULL_DATABASE |
AQ_USER_ROLE |
AQ_ADMINISTRATOR_ROLE |
SNMPAGENT |
RECOVERY_CATALOG_OWNER |
HS_ADMIN_ROLE |
SCHEDULER_ADMIN |
関連事項