Created
October 27, 2022 15:55
-
-
Save adriasir123/5cd2ec8d56974b6ae0d283243f6d5f41 to your computer and use it in GitHub Desktop.
Output of BIBLIOFILOS_ADMIN privileges in Oracle
This file contains hidden or 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 * from dba_sys_privs where grantee = 'BIBLIOFILOS_ADMIN'; | |
| GRANTEE PRIVILEGE ADM COM INH | |
| ----------------- ---------------------------------------- --- --- --- | |
| BIBLIOFILOS_ADMIN CREATE ANALYTIC VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY CUBE BUILD PROCESS NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE LOCKDOWN PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN EM EXPRESS CONNECT NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY SQL TRANSLATION PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN UPDATE ANY CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN DELETE ANY CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY MINING MODEL NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY ASSEMBLY NO YES NO | |
| BIBLIOFILOS_ADMIN MANAGE FILE GROUP NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY RULE NO YES NO | |
| BIBLIOFILOS_ADMIN GRANT ANY OBJECT PRIVILEGE NO YES NO | |
| BIBLIOFILOS_ADMIN DEBUG CONNECT ANY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY CONTEXT NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN UNDER ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN GLOBAL QUERY REWRITE NO YES NO | |
| BIBLIOFILOS_ADMIN QUERY REWRITE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY INDEXTYPE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY OPERATOR NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY LIBRARY NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY TYPE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY DIRECTORY NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY TRIGGER NO YES NO | |
| BIBLIOFILOS_ADMIN AUDIT ANY NO YES NO | |
| BIBLIOFILOS_ADMIN DROP PUBLIC SYNONYM NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY SYNONYM NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER USER NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE TABLESPACE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER SYSTEM NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE HIERARCHY NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY ATTRIBUTE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY SQL TRANSLATION PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE CUBE BUILD PROCESS NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE MEASURE FOLDER NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY CUBE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY MINING MODEL NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY ASSEMBLY NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY TRANSACTION NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE JOB NO YES NO | |
| BIBLIOFILOS_ADMIN DEBUG ANY PROCEDURE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY CONTEXT NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY LIBRARY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY MATERIALIZED VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN GRANT ANY PRIVILEGE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE PUBLIC DATABASE LINK NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE DATABASE LINK NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY SEQUENCE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY INDEX NO YES NO | |
| BIBLIOFILOS_ADMIN DELETE ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN LOCK ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ROLLBACK SEGMENT NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE USER NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER SESSION NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY ANALYTIC VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY ANALYTIC VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY HIERARCHY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ATTRIBUTE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY MEASURE FOLDER NO YES NO | |
| BIBLIOFILOS_ADMIN LOGMINING NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY CREDENTIAL NO YES NO | |
| BIBLIOFILOS_ADMIN INSERT ANY MEASURE FOLDER NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY MEASURE FOLDER NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY CUBE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY EDITION NO YES NO | |
| BIBLIOFILOS_ADMIN MANAGE ANY FILE GROUP NO YES NO | |
| BIBLIOFILOS_ADMIN MANAGE SCHEDULER NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY CLASS NO YES NO | |
| BIBLIOFILOS_ADMIN EXPORT FULL DATABASE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY RULE SET NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY EVALUATION CONTEXT NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY EVALUATION CONTEXT NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE EVALUATION CONTEXT NO YES NO | |
| BIBLIOFILOS_ADMIN DEQUEUE ANY QUEUE NO YES NO | |
| BIBLIOFILOS_ADMIN ENQUEUE ANY QUEUE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE TYPE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY DIRECTORY NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER RESOURCE COST NO YES NO | |
| BIBLIOFILOS_ADMIN DROP PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY PROCEDURE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY ROLE NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY SEQUENCE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY SYNONYM NO YES NO | |
| BIBLIOFILOS_ADMIN UPDATE ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN BECOME USER NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY ATTRIBUTE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY CUBE BUILD PROCESS NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE PLUGGABLE DATABASE NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY MINING MODEL NO YES NO | |
| BIBLIOFILOS_ADMIN READ ANY FILE GROUP NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY SQL PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN ADMINISTER SQL TUNING SET NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY SQL PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY PROGRAM NO YES NO | |
| BIBLIOFILOS_ADMIN ADVISOR NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE RULE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY INDEXTYPE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE OPERATOR NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY LIBRARY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY LIBRARY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE LIBRARY NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY TYPE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY MATERIALIZED VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY PROCEDURE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE PUBLIC SYNONYM NO YES NO | |
| BIBLIOFILOS_ADMIN INSERT ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN RESTRICTED SESSION NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY HIERARCHY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY ATTRIBUTE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN USE ANY JOB RESOURCE NO YES NO | |
| BIBLIOFILOS_ADMIN INSERT ANY CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN COMMENT ANY MINING MODEL NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY ASSEMBLY NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY EDITION NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY RULE SET NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY EVALUATION CONTEXT NO YES NO | |
| BIBLIOFILOS_ADMIN FLASHBACK ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN ADMINISTER RESOURCE MANAGER NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE INDEXTYPE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY OPERATOR NO YES NO | |
| BIBLIOFILOS_ADMIN FORCE TRANSACTION NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER DATABASE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ROLE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY SEQUENCE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY INDEX NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE CLUSTER NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN COMMENT ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN BACKUP ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP USER NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER TABLESPACE NO YES NO | |
| BIBLIOFILOS_ADMIN AUDIT SYSTEM NO YES NO | |
| BIBLIOFILOS_ADMIN READ ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE CREDENTIAL NO YES NO | |
| BIBLIOFILOS_ADMIN USE ANY SQL TRANSLATION PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE SQL TRANSLATION PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN ADMINISTER SQL MANAGEMENT OBJECT NO YES NO | |
| BIBLIOFILOS_ADMIN UPDATE ANY CUBE BUILD PROCESS NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE CUBE NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ASSEMBLY NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY SQL PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY RULE NO YES NO | |
| BIBLIOFILOS_ADMIN RESUMABLE NO YES NO | |
| BIBLIOFILOS_ADMIN ADMINISTER DATABASE TRIGGER NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY OUTLINE NO YES NO | |
| BIBLIOFILOS_ADMIN MANAGE ANY QUEUE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY OPERATOR NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY OPERATOR NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY TRIGGER NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY PROCEDURE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE PROCEDURE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY ROLE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY SEQUENCE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY CLUSTER NO YES NO | |
| BIBLIOFILOS_ADMIN UNLIMITED TABLESPACE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE SESSION NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY ANALYTIC VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY MEASURE FOLDER NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER LOCKDOWN PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY SQL TRANSLATION PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY CUBE BUILD PROCESS NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY MEASURE FOLDER NO YES NO | |
| BIBLIOFILOS_ADMIN UPDATE ANY CUBE NO YES NO | |
| BIBLIOFILOS_ADMIN SELECT ANY CUBE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY CUBE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY MINING MODEL NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY ASSEMBLY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY EDITION NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY JOB NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY RULE NO YES NO | |
| BIBLIOFILOS_ADMIN IMPORT FULL DATABASE NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY RULE SET NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE RULE SET NO YES NO | |
| BIBLIOFILOS_ADMIN ON COMMIT REFRESH NO YES NO | |
| BIBLIOFILOS_ADMIN MERGE ANY VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY OUTLINE NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY INDEXTYPE NO YES NO | |
| BIBLIOFILOS_ADMIN UNDER ANY TYPE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY MATERIALIZED VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE MATERIALIZED VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN ANALYZE ANY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY TRIGGER NO YES NO | |
| BIBLIOFILOS_ADMIN FORCE ANY TRANSACTION NO YES NO | |
| BIBLIOFILOS_ADMIN GRANT ANY ROLE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP PUBLIC DATABASE LINK NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE SEQUENCE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY INDEX NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY CLUSTER NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ROLLBACK SEGMENT NO YES NO | |
| BIBLIOFILOS_ADMIN DROP TABLESPACE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY HIERARCHY NO YES NO | |
| BIBLIOFILOS_ADMIN DROP LOCKDOWN PROFILE NO YES NO | |
| BIBLIOFILOS_ADMIN SET CONTAINER NO YES NO | |
| BIBLIOFILOS_ADMIN FLASHBACK ARCHIVE ADMINISTER NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY CUBE BUILD PROCESS NO YES NO | |
| BIBLIOFILOS_ADMIN DELETE ANY MEASURE FOLDER NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE CUBE DIMENSION NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE MINING MODEL NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ASSEMBLY NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE EXTERNAL JOB NO YES NO | |
| BIBLIOFILOS_ADMIN CHANGE NOTIFICATION NO YES NO | |
| BIBLIOFILOS_ADMIN ADMINISTER ANY SQL TUNING SET NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY RULE NO YES NO | |
| BIBLIOFILOS_ADMIN ALTER ANY RULE SET NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY EVALUATION CONTEXT NO YES NO | |
| BIBLIOFILOS_ADMIN DEBUG CONNECT SESSION NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY OUTLINE NO YES NO | |
| BIBLIOFILOS_ADMIN UNDER ANY VIEW NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY INDEXTYPE NO YES NO | |
| BIBLIOFILOS_ADMIN EXECUTE ANY TYPE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE ANY TYPE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE TRIGGER NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY PROCEDURE NO YES NO | |
| BIBLIOFILOS_ADMIN CREATE SYNONYM NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY CLUSTER NO YES NO | |
| BIBLIOFILOS_ADMIN REDEFINE ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ANY TABLE NO YES NO | |
| BIBLIOFILOS_ADMIN DROP ROLLBACK SEGMENT NO YES NO | |
| BIBLIOFILOS_ADMIN MANAGE TABLESPACE NO YES NO | |
| 234 rows selected. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment