システム権限一覧
システム権限の種類と各サブタイプ(オプション)一覧
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 |
関連事項
