Skip to content

Instantly share code, notes, and snippets.

@adriasir123
Created January 21, 2023 00:59
Show Gist options
  • Save adriasir123/51f018d18d794f9d66db8c72aa6a7134 to your computer and use it in GitHub Desktop.
Save adriasir123/51f018d18d794f9d66db8c72aa6a7134 to your computer and use it in GitHub Desktop.
Output de `SELECT role FROM DBA_ROLES;`
ROLE
--------------------------------------------------------------------------------------------------------------------------------
CONNECT
RESOURCE
DBA
PDB_DBA
AUDIT_ADMIN
AUDIT_VIEWER
SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
CAPTURE_ADMIN
EXP_FULL_DATABASE
IMP_FULL_DATABASE
CDB_DBA
APPLICATION_TRACE_VIEWER
LOGSTDBY_ADMINISTRATOR
DBFS_ROLE
GSMUSER_ROLE
GSMROOTUSER_ROLE
AQ_ADMINISTRATOR_ROLE
AQ_USER_ROLE
DATAPUMP_EXP_FULL_DATABASE
DATAPUMP_IMP_FULL_DATABASE
ADM_PARALLEL_EXECUTE_TASK
PROVISIONER
XS_SESSION_ADMIN
XS_NAMESPACE_ADMIN
XS_CACHE_ADMIN
XS_CONNECT
OEM_MONITOR
GATHER_SYSTEM_STATISTICS
OPTIMIZER_PROCESSING_RATE
DBMS_MDX_INTERNAL
BDSQL_ADMIN
BDSQL_USER
RECOVERY_CATALOG_OWNER
RECOVERY_CATALOG_OWNER_VPD
RECOVERY_CATALOG_USER
EM_EXPRESS_BASIC
EM_EXPRESS_ALL
SYSUMF_ROLE
SCHEDULER_ADMIN
HS_ADMIN_SELECT_ROLE
HS_ADMIN_EXECUTE_ROLE
HS_ADMIN_ROLE
GLOBAL_AQ_USER_ROLE
OEM_ADVISOR
JAVAUSERPRIV
GSMADMIN_ROLE
GSM_POOLADMIN_ROLE
GDS_CATALOG_SELECT
GGSYS_ROLE
XDBADMIN
XDB_SET_INVOKER
AUTHENTICATEDUSER
XDB_WEBSERVICES
XDB_WEBSERVICES_WITH_PUBLIC
XDB_WEBSERVICES_OVER_HTTP
SODA_APP
DATAPATCH_ROLE
WM_ADMIN_ROLE
JAVAIDPRIV
JAVASYSPRIV
JAVADEBUGPRIV
EJBCLIENT
JMXSERVER
DBJAVASCRIPT
JAVA_ADMIN
CTXAPP
ORDADMIN
OLAP_XS_ADMIN
OLAP_DBA
OLAP_USER
DV_SECANALYST
RDFCTX_ADMIN
LBAC_DBA
DV_REALM_OWNER
DV_MONITOR
DV_ADMIN
DV_OWNER
DV_ACCTMGR
DV_PUBLIC
DV_PATCH_ADMIN
DV_STREAMS_ADMIN
DV_GOLDENGATE_ADMIN
DV_XSTREAM_ADMIN
DV_GOLDENGATE_REDO_ACCESS
DV_AUDIT_CLEANUP
DV_DATAPUMP_NETWORK_LINK
DV_POLICY_OWNER
DV_REALM_RESOURCE
ROLPRACTICA1
90 rows selected.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment