Skip to content

Instantly share code, notes, and snippets.

@adriasir123

adriasir123/gist:4b68f6910cdcbca08ab7556c14f06289

Created December 10, 2022 20:29
Show Gist options
  • Save adriasir123/4b68f6910cdcbca08ab7556c14f06289 to your computer and use it in GitHub Desktop.
Save adriasir123/4b68f6910cdcbca08ab7556c14f06289 to your computer and use it in GitHub Desktop.
Download ZIP
Output de `EXEC mostrar_privilegios_usuario('SYS');`
Raw
gistfile1.txt
El usuario recibido ha sido: SYS
Sus privilegios de sistema son:
ALTER ANY ANALYTIC VIEW
DROP ANY HIERARCHY
LOGMINING
DROP LOCKDOWN PROFILE
INHERIT ANY PRIVILEGES
CREATE ANY MEASURE FOLDER
DROP ANY CUBE
DROP ANY ASSEMBLY
MANAGE ANY FILE GROUP
DROP ANY SQL PROFILE
ALTER ANY RULE
CREATE RULE
EXECUTE ANY RULE SET
CREATE ANY RULE SET
DEBUG CONNECT SESSION
ON COMMIT REFRESH
CREATE OPERATOR
DROP ANY VIEW
CREATE VIEW
CREATE PUBLIC SYNONYM
DROP ANY CLUSTER
ALTER USER
SELECT ANY CUBE BUILD PROCESS
CREATE LOCKDOWN PROFILE
FLASHBACK ARCHIVE ADMINISTER
DROP ANY CUBE BUILD PROCESS
CREATE CUBE BUILD PROCESS
DROP ANY MEASURE FOLDER
SELECT ANY CUBE DIMENSION
EXECUTE ASSEMBLY
ALTER ANY EDITION
SELECT ANY TRANSACTION
DROP ANY RULE
FLASHBACK ANY TABLE
UNDER ANY VIEW
CREATE ANY INDEXTYPE
CREATE ANY OPERATOR
EXECUTE ANY TYPE
CREATE PROFILE
DROP ANY TRIGGER
DROP PUBLIC DATABASE LINK
CREATE ANY VIEW
DROP PUBLIC SYNONYM
DROP ANY SYNONYM
DROP ANY INDEX
CREATE CLUSTER
DROP USER
UNLIMITED TABLESPACE
CREATE ANALYTIC VIEW
DROP ANY ATTRIBUTE DIMENSION
CREATE ANY CREDENTIAL
EM EXPRESS CONNECT
DELETE ANY MEASURE FOLDER
UPDATE ANY CUBE
DELETE ANY CUBE DIMENSION
CREATE CUBE DIMENSION
CHANGE NOTIFICATION
ADMINISTER ANY SQL TUNING SET
CREATE JOB
IMPORT FULL DATABASE
CREATE RULE SET
RESUMABLE
ALTER ANY OUTLINE
DROP ANY DIMENSION
CREATE ANY DIMENSION
CREATE INDEXTYPE
CREATE ANY LIBRARY
DROP ANY DIRECTORY
CREATE ANY DIRECTORY
CREATE MATERIALIZED VIEW
ALTER DATABASE
GRANT ANY ROLE
DROP ANY ROLE
CREATE ANY SEQUENCE
DELETE ANY TABLE
DROP ANY ANALYTIC VIEW
USE ANY JOB RESOURCE
CREATE CREDENTIAL
ALTER LOCKDOWN PROFILE
SELECT ANY CUBE
CREATE CUBE
DROP ANY CUBE DIMENSION
CREATE ANY ASSEMBLY
CREATE ASSEMBLY
READ ANY FILE GROUP
MANAGE FILE GROUP
EXECUTE ANY RULE
CREATE ANY RULE
EXPORT FULL DATABASE
ALTER ANY EVALUATION CONTEXT
CREATE ANY EVALUATION CONTEXT
GRANT ANY OBJECT PRIVILEGE
GLOBAL QUERY REWRITE
ALTER ANY LIBRARY
CREATE TYPE
ALTER ANY MATERIALIZED VIEW
CREATE ANY TRIGGER
CREATE PROCEDURE
FORCE TRANSACTION
CREATE SEQUENCE
CREATE SYNONYM
INSERT ANY TABLE
ALTER ANY TABLE
DROP ROLLBACK SEGMENT
DROP TABLESPACE
MANAGE TABLESPACE
ALTER SESSION
CREATE ATTRIBUTE DIMENSION
USE ANY SQL TRANSLATION PROFILE
UPDATE ANY CUBE BUILD PROCESS
CREATE MEASURE FOLDER
ALTER ANY CUBE
MANAGE SCHEDULER
EXECUTE ANY PROGRAM
ALTER ANY RULE SET
ADMINISTER DATABASE TRIGGER
UNDER ANY TABLE
ALTER ANY INDEXTYPE
DROP ANY OPERATOR
ALTER ANY OPERATOR
DROP ANY LIBRARY
CREATE LIBRARY
UNDER ANY TYPE
ALTER ANY TYPE
CREATE ANY TYPE
CREATE ANY MATERIALIZED VIEW
ALTER ANY TRIGGER
CREATE TRIGGER
ALTER ANY PROCEDURE
CREATE ANY PROCEDURE
CREATE PUBLIC DATABASE LINK
SELECT ANY SEQUENCE
DROP ANY SEQUENCE
CREATE ANY SYNONYM
DROP ANY TABLE
ALTER ROLLBACK SEGMENT
CREATE USER
ALTER TABLESPACE
AUDIT SYSTEM
ALTER SYSTEM
ALTER ANY HIERARCHY
CREATE HIERARCHY
ALTER ANY MEASURE FOLDER
CREATE ANY SQL TRANSLATION PROFILE
CREATE ANY CUBE BUILD PROCESS
CREATE ANY CUBE
CREATE ANY MINING MODEL
EXECUTE ANY ASSEMBLY
ALTER ANY ASSEMBLY
CREATE ANY EDITION
CREATE EXTERNAL JOB
EXECUTE ANY CLASS
CREATE ANY JOB
DROP ANY EVALUATION CONTEXT
DEBUG ANY PROCEDURE
MERGE ANY VIEW
DROP ANY CONTEXT
ENQUEUE ANY QUEUE
EXECUTE ANY INDEXTYPE
ALTER RESOURCE COST
DROP PROFILE
ALTER PROFILE
EXECUTE ANY PROCEDURE
FORCE ANY TRANSACTION
AUDIT ANY
ALTER ANY ROLE
CREATE ANY CLUSTER
COMMENT ANY TABLE
CREATE ANY TABLE
CREATE TABLE
CREATE TABLESPACE
CREATE ANY ANALYTIC VIEW
CREATE ANY ATTRIBUTE DIMENSION
READ ANY TABLE
SELECT ANY MEASURE FOLDER
DROP ANY SQL TRANSLATION PROFILE
ALTER ANY SQL TRANSLATION PROFILE
UPDATE ANY CUBE DIMENSION
INSERT ANY MEASURE FOLDER
CREATE ANY CUBE DIMENSION
ALTER ANY CUBE DIMENSION
ALTER ANY MINING MODEL
DROP ANY MINING MODEL
DROP ANY EDITION
ADMINISTER SQL TUNING SET
ALTER ANY SQL PROFILE
DROP ANY RULE SET
EXECUTE ANY EVALUATION CONTEXT
ADMINISTER RESOURCE MANAGER
DROP ANY OUTLINE
DEQUEUE ANY QUEUE
ALTER ANY DIMENSION
CREATE DIMENSION
QUERY REWRITE
EXECUTE ANY LIBRARY
GRANT ANY PRIVILEGE
CREATE ROLE
ALTER ANY SEQUENCE
ALTER ANY CLUSTER
REDEFINE ANY TABLE
LOCK ANY TABLE
BACKUP ANY TABLE
CREATE ANY HIERARCHY
ALTER ANY ATTRIBUTE DIMENSION
ALTER ANY CUBE BUILD PROCESS
SET CONTAINER
CREATE PLUGGABLE DATABASE
CREATE SQL TRANSLATION PROFILE
ADMINISTER SQL MANAGEMENT OBJECT
INSERT ANY CUBE DIMENSION
COMMENT ANY MINING MODEL
SELECT ANY MINING MODEL
CREATE MINING MODEL
CREATE ANY SQL PROFILE
ADVISOR
CREATE EVALUATION CONTEXT
DEBUG CONNECT ANY
CREATE ANY OUTLINE
CREATE ANY CONTEXT
MANAGE ANY QUEUE
DROP ANY INDEXTYPE
EXECUTE ANY OPERATOR
DROP ANY TYPE
DROP ANY MATERIALIZED VIEW
ANALYZE ANY
DROP ANY PROCEDURE
CREATE DATABASE LINK
ALTER ANY INDEX
CREATE ANY INDEX
UPDATE ANY TABLE
SELECT ANY TABLE
CREATE ROLLBACK SEGMENT
BECOME USER
RESTRICTED SESSION
CREATE SESSION
Sus privilegios sobre objetos son:
EXECUTE sobre LBAC_STANDARD
EXECUTE sobre LBAC_SERVICES
SELECT sobre DBA_DV_STATUS
EXECUTE sobre CONFIGURE_DV_INTERNAL
SELECT sobre OL$
SELECT sobre OL$HINTS
SELECT sobre OL$NODES
PL/SQL procedure successfully completed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment