Created
November 19, 2018 13:18
-
-
Save mago1chi/f6c0f6912a9f36f5bd6cfc4af68ff3db to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SQL> select username, privilege, admin_option, common from user_sys_privs; | |
| USERNAME PRIVILEGE ADMIN_OPTION COMMON | |
| ---------------------------------------- ---------------------------------------- ------------------------------ ------------------------------ | |
| ADMIN CREATE HIERARCHY YES NO | |
| ADMIN CREATE ATTRIBUTE DIMENSION YES NO | |
| ADMIN EXEMPT REDACTION POLICY YES NO | |
| ADMIN INSERT ANY MEASURE FOLDER YES NO | |
| ADMIN ALTER ANY MINING MODEL YES NO | |
| ADMIN EXECUTE ASSEMBLY YES NO | |
| ADMIN ADMINISTER SQL TUNING SET YES NO | |
| ADMIN ALTER ANY SQL PROFILE YES NO | |
| ADMIN ADVISOR YES NO | |
| ADMIN DROP ANY RULE YES NO | |
| ADMIN CREATE ANY RULE YES NO | |
| ADMIN CREATE RULE YES NO | |
| ADMIN CREATE ANY RULE SET YES NO | |
| ADMIN EXECUTE ANY INDEXTYPE YES NO | |
| ADMIN ALTER ANY LIBRARY YES NO | |
| ADMIN ALTER RESOURCE COST YES NO | |
| ADMIN ALTER ANY ROLE YES NO | |
| ADMIN CREATE SEQUENCE YES NO | |
| ADMIN CREATE ANY INDEX YES NO | |
| ADMIN ALTER ANY CLUSTER YES NO | |
| ADMIN DROP ROLLBACK SEGMENT YES NO | |
| ADMIN ALTER USER YES NO | |
| ADMIN DROP TABLESPACE YES NO | |
| ADMIN CREATE TABLESPACE YES NO | |
| ADMIN ALTER SESSION YES NO | |
| ADMIN ALTER ANY ATTRIBUTE DIMENSION YES NO | |
| ADMIN CREATE SQL TRANSLATION PROFILE YES NO | |
| ADMIN CREATE MEASURE FOLDER YES NO | |
| ADMIN CREATE CUBE YES NO | |
| ADMIN EXECUTE ANY ASSEMBLY YES NO | |
| ADMIN CREATE ANY EDITION YES NO | |
| ADMIN DROP ANY SQL PROFILE YES NO | |
| ADMIN DROP ANY EVALUATION CONTEXT YES NO | |
| ADMIN SELECT ANY DICTIONARY YES NO | |
| ADMIN MERGE ANY VIEW YES NO | |
| ADMIN ADMINISTER RESOURCE MANAGER YES NO | |
| ADMIN DROP ANY DIMENSION YES NO | |
| ADMIN CREATE ANY OPERATOR YES NO | |
| ADMIN UNDER ANY TYPE YES NO | |
| ADMIN DROP PROFILE YES NO | |
| ADMIN CREATE PROFILE YES NO | |
| ADMIN CREATE TRIGGER YES NO | |
| ADMIN EXECUTE ANY PROCEDURE YES NO | |
| ADMIN CREATE PUBLIC SYNONYM YES NO | |
| ADMIN CREATE TABLE YES NO | |
| ADMIN ALTER ROLLBACK SEGMENT YES NO | |
| PUBLIC UNLIMITED TABLESPACE NO NO | |
| ADMIN AUDIT SYSTEM YES NO | |
| ADMIN ALTER SYSTEM YES NO | |
| ADMIN CREATE ANALYTIC VIEW YES NO | |
| ADMIN CREATE ANY ATTRIBUTE DIMENSION YES NO | |
| ADMIN ALTER ANY CUBE BUILD PROCESS YES NO | |
| ADMIN DROP LOCKDOWN PROFILE YES NO | |
| ADMIN CREATE PLUGGABLE DATABASE YES NO | |
| ADMIN ADMINISTER SQL MANAGEMENT OBJECT YES NO | |
| ADMIN UPDATE ANY CUBE YES NO | |
| ADMIN SELECT ANY CUBE DIMENSION YES NO | |
| ADMIN DROP ANY ASSEMBLY YES NO | |
| ADMIN ALTER ANY ASSEMBLY YES NO | |
| ADMIN DEBUG ANY PROCEDURE YES NO | |
| ADMIN DROP ANY OUTLINE YES NO | |
| ADMIN CREATE ANY OUTLINE YES NO | |
| ADMIN DROP ANY CONTEXT YES NO | |
| ADMIN UNDER ANY TABLE YES NO | |
| ADMIN EXECUTE ANY OPERATOR YES NO | |
| ADMIN EXECUTE ANY TYPE YES NO | |
| ADMIN DROP ANY TYPE YES NO | |
| ADMIN ALTER ANY TRIGGER YES NO | |
| ADMIN ALTER ANY PROCEDURE YES NO | |
| ADMIN CREATE VIEW YES NO | |
| ADMIN CREATE ANY SYNONYM YES NO | |
| ADMIN DROP ANY CLUSTER YES NO | |
| ADMIN CREATE CLUSTER YES NO | |
| ADMIN SELECT ANY TABLE YES NO | |
| ADMIN ALTER TABLESPACE YES NO | |
| ADMIN CREATE ANY ANALYTIC VIEW YES NO | |
| ADMIN ALTER ANY HIERARCHY YES NO | |
| ADMIN READ ANY TABLE YES NO | |
| ADMIN ALTER ANY MEASURE FOLDER YES NO | |
| ADMIN UPDATE ANY CUBE DIMENSION YES NO | |
| ADMIN ALTER ANY EDITION YES NO | |
| ADMIN ADMINISTER ANY SQL TUNING SET YES NO | |
| ADMIN ALTER ANY RULE YES NO | |
| ADMIN ALTER ANY EVALUATION CONTEXT YES NO | |
| ADMIN RESUMABLE YES NO | |
| ADMIN ON COMMIT REFRESH YES NO | |
| ADMIN QUERY REWRITE YES NO | |
| ADMIN UNDER ANY VIEW YES NO | |
| ADMIN ALTER ANY INDEXTYPE YES NO | |
| ADMIN CREATE INDEXTYPE YES NO | |
| ADMIN EXECUTE ANY LIBRARY YES NO | |
| ADMIN DROP ANY MATERIALIZED VIEW YES NO | |
| ADMIN DROP ANY PROCEDURE YES NO | |
| ADMIN DROP PUBLIC DATABASE LINK YES NO | |
| ADMIN DROP ANY VIEW YES NO | |
| ADMIN DROP ANY INDEX YES NO | |
| ADMIN ALTER ANY INDEX YES NO | |
| ADMIN INSERT ANY TABLE YES NO | |
| ADMIN DROP ANY TABLE YES NO | |
| ADMIN CREATE ANY TABLE YES NO | |
| ADMIN RESTRICTED SESSION YES NO | |
| ADMIN SELECT ANY MEASURE FOLDER YES NO | |
| ADMIN ALTER LOCKDOWN PROFILE YES NO | |
| ADMIN PURGE DBA_RECYCLEBIN YES NO | |
| ADMIN CREATE ANY CUBE BUILD PROCESS YES NO | |
| ADMIN CREATE ANY CUBE YES NO | |
| ADMIN DROP ANY CUBE DIMENSION YES NO | |
| ADMIN ALTER ANY CUBE DIMENSION YES NO | |
| ADMIN COMMENT ANY MINING MODEL YES NO | |
| ADMIN SELECT ANY MINING MODEL YES NO | |
| ADMIN READ ANY FILE GROUP YES NO | |
| ADMIN ALTER ANY RULE SET YES NO | |
| ADMIN EXECUTE ANY EVALUATION CONTEXT YES NO | |
| ADMIN DROP ANY INDEXTYPE YES NO | |
| ADMIN CREATE ANY INDEXTYPE YES NO | |
| ADMIN DROP ANY OPERATOR YES NO | |
| ADMIN ALTER ANY OPERATOR YES NO | |
| ADMIN DROP ANY TRIGGER YES NO | |
| ADMIN FORCE ANY TRANSACTION YES NO | |
| ADMIN ALTER DATABASE YES NO | |
| ADMIN SELECT ANY SEQUENCE YES NO | |
| ADMIN REDEFINE ANY TABLE YES NO | |
| ADMIN ALTER ANY TABLE YES NO | |
| ADMIN CREATE SESSION YES NO | |
| ADMIN ALTER ANY ANALYTIC VIEW YES NO | |
| ADMIN CREATE LOCKDOWN PROFILE YES NO | |
| ADMIN ALTER ANY SQL TRANSLATION PROFILE YES NO | |
| ADMIN CREATE ANY SQL TRANSLATION PROFILE YES NO | |
| ADMIN UPDATE ANY CUBE BUILD PROCESS YES NO | |
| ADMIN DROP ANY MEASURE FOLDER YES NO | |
| ADMIN ALTER ANY CUBE YES NO | |
| ADMIN INSERT ANY CUBE DIMENSION YES NO | |
| ADMIN CREATE CUBE DIMENSION YES NO | |
| ADMIN DROP ANY MINING MODEL YES NO | |
| ADMIN CREATE ANY ASSEMBLY YES NO | |
| ADMIN CREATE ASSEMBLY YES NO | |
| ADMIN DROP ANY RULE SET YES NO | |
| ADMIN DEBUG CONNECT ANY YES NO | |
| ADMIN CREATE ANY CONTEXT YES NO | |
| ADMIN DROP ANY LIBRARY YES NO | |
| ADMIN CREATE ANY TYPE YES NO | |
| ADMIN CREATE ANY MATERIALIZED VIEW YES NO | |
| ADMIN CREATE ANY TRIGGER YES NO | |
| ADMIN CREATE PROCEDURE YES NO | |
| ADMIN CREATE ROLE YES NO | |
| ADMIN CREATE DATABASE LINK YES NO | |
| ADMIN DROP ANY SEQUENCE YES NO | |
| ADMIN ALTER ANY SEQUENCE YES NO | |
| ADMIN CREATE SYNONYM YES NO | |
| ADMIN CREATE ANY CLUSTER YES NO | |
| ADMIN UPDATE ANY TABLE YES NO | |
| ADMIN CREATE USER YES NO | |
| ADMIN DROP ANY ANALYTIC VIEW YES NO | |
| ADMIN DROP ANY HIERARCHY YES NO | |
| ADMIN DROP ANY ATTRIBUTE DIMENSION YES NO | |
| ADMIN SELECT ANY CUBE BUILD PROCESS YES NO | |
| ADMIN DROP ANY CUBE BUILD PROCESS YES NO | |
| ADMIN CREATE ANY MEASURE FOLDER YES NO | |
| ADMIN SELECT ANY CUBE YES NO | |
| ADMIN DELETE ANY CUBE DIMENSION YES NO | |
| ADMIN CREATE ANY MINING MODEL YES NO | |
| ADMIN EXECUTE ANY CLASS YES NO | |
| ADMIN EXECUTE ANY PROGRAM YES NO | |
| ADMIN ANALYZE ANY DICTIONARY YES NO | |
| ADMIN EXECUTE ANY RULE YES NO | |
| ADMIN CREATE EVALUATION CONTEXT YES NO | |
| ADMIN GRANT ANY OBJECT PRIVILEGE YES NO | |
| ADMIN DEBUG CONNECT SESSION YES NO | |
| ADMIN ADMINISTER DATABASE TRIGGER YES NO | |
| ADMIN CREATE ANY DIMENSION YES NO | |
| ADMIN CREATE DIMENSION YES NO | |
| ADMIN ALTER ANY TYPE YES NO | |
| ADMIN CREATE TYPE YES NO | |
| ADMIN ANALYZE ANY YES NO | |
| ADMIN ALTER PROFILE YES NO | |
| ADMIN CREATE ANY PROCEDURE YES NO | |
| ADMIN DROP ANY ROLE YES NO | |
| ADMIN CREATE PUBLIC DATABASE LINK YES NO | |
| ADMIN DROP PUBLIC SYNONYM YES NO | |
| ADMIN DELETE ANY TABLE YES NO | |
| ADMIN COMMENT ANY TABLE YES NO | |
| ADMIN LOCK ANY TABLE YES NO | |
| ADMIN CREATE ROLLBACK SEGMENT YES NO | |
| ADMIN UNLIMITED TABLESPACE YES NO | |
| ADMIN MANAGE TABLESPACE YES NO | |
| ADMIN CREATE ANY HIERARCHY YES NO | |
| ADMIN DROP ANY SQL TRANSLATION PROFILE YES NO | |
| ADMIN CREATE CUBE BUILD PROCESS YES NO | |
| ADMIN DELETE ANY MEASURE FOLDER YES NO | |
| ADMIN DROP ANY CUBE YES NO | |
| ADMIN CREATE ANY CUBE DIMENSION YES NO | |
| ADMIN CREATE MINING MODEL YES NO | |
| ADMIN DROP ANY EDITION YES NO | |
| ADMIN CHANGE NOTIFICATION YES NO | |
| ADMIN CREATE ANY SQL PROFILE YES NO | |
| ADMIN SELECT ANY TRANSACTION YES NO | |
| ADMIN CREATE JOB YES NO | |
| ADMIN EXECUTE ANY RULE SET YES NO | |
| ADMIN CREATE RULE SET YES NO | |
| ADMIN CREATE ANY EVALUATION CONTEXT YES NO | |
| ADMIN ALTER ANY OUTLINE YES NO | |
| ADMIN ALTER ANY DIMENSION YES NO | |
| ADMIN GLOBAL QUERY REWRITE YES NO | |
| ADMIN CREATE OPERATOR YES NO | |
| ADMIN ALTER ANY MATERIALIZED VIEW YES NO | |
| ADMIN CREATE MATERIALIZED VIEW YES NO | |
| ADMIN AUDIT ANY YES NO | |
| ADMIN CREATE ANY SEQUENCE YES NO | |
| ADMIN CREATE ANY VIEW YES NO | |
| ADMIN DROP ANY SYNONYM YES NO | |
| ADMIN DROP USER YES NO | |
| 211行が選択されました。 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment