システム権限一覧
システム権限の種類と各サブタイプ(オプション)一覧
例えば 権限名 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 |
関連事項
|
■
■
■
印刷表示