[Home] [Help] [Dependency Information]

VIEW: SYS.SESSION_ROLES

Object Details

Roles which the user currently has enabled.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROLE
FROM SYS.SESSION_ROLES;

Dependencies

[top of page]

SYS

USER$

DVSYS

KU$_DV_COMMAND_RULE_VIEW

KU$_DV_FACTOR_LINK_VIEW

KU$_DV_FACTOR_TYPE_VIEW

KU$_DV_FACTOR_VIEW

KU$_DV_IDENTITY_MAP_VIEW

KU$_DV_IDENTITY_VIEW

KU$_DV_ISRM_VIEW

KU$_DV_ISR_VIEW

KU$_DV_REALM_AUTH_VIEW

KU$_DV_REALM_MEMBER_VIEW

KU$_DV_REALM_VIEW

KU$_DV_ROLE_VIEW

KU$_DV_RULE_SET_MEMBER_VIEW

KU$_DV_RULE_SET_VIEW

KU$_DV_RULE_VIEW

PUBLIC

SESSION_ROLES

SYS

DBMS_METADATA - show dependent code

DBMS_PRIV_CAPTURE - show dependent code

DBMS_SCHED_ARGUMENT_IMPORT - show dependent code

EXPGETENCCOLNAM

EXPGETMAPOBJ

EXPMAPIOT

EXPPIOTMAP

EXU10AOBJSWITCH

EXU10DOSO

EXU10LNK

EXU10MVL

EXU10OBJSWITCH

EXU10R2OBJSWITCH

EXU11IND_BASE

EXU81ASSOC

EXU81JAV

EXU81NOS

EXU81PROCOBJ

EXU81RLS

EXU8DIM

EXU8ICO

EXU8ORFS

EXU92TSP

EXU92TSPL

EXU9ACTIONOBJ

EXU9BJF

EXU9BJW

EXU9DOSO

EXU9EIP

EXU9FGA

EXU9INHCOLCONS

EXU9MVL

EXU9MVLCDCCC

EXU9MVLCDCS

EXU9MVLCDCSC

EXU9MVLCDCST

EXU9NOS

EXU9OBJSWITCH

EXU9PCT

EXU9PGP

EXU9RLS

EXU9XTB

IMP9SYN4

IMP9TVOID

KU$_10_1_IND_STATS_VIEW

KU$_10_1_TAB_STATS_VIEW

KU$_10_2_FHTABLE_VIEW

KU$_10_2_IND_STATS_VIEW

KU$_10_2_STRMTABLE_VIEW

KU$_10_2_TAB_STATS_VIEW

KU$_11_2_IND_STATS_VIEW

KU$_11_2_TAB_STATS_VIEW

KU$_2ND_TABLE_OBJNUM_VIEW

KU$_ACPTABLE_VIEW

KU$_ALL_INDEX_VIEW

KU$_ALTER_FUNC_VIEW

KU$_ALTER_PKGBDY_VIEW

KU$_ALTER_PKGSPC_VIEW

KU$_ALTER_PROC_VIEW

KU$_ASSOC_VIEW

KU$_AUDIT_OBJ_VIEW

KU$_AUDIT_VIEW

KU$_BASE_PROC_OBJNUM_VIEW

KU$_BASE_PROC_VIEW

KU$_CLUSTER_VIEW

KU$_CLU_TS_VIEW

KU$_COMMENT_VIEW

KU$_CONSTRAINT_EXISTS_VIEW

KU$_CONSTRAINT_VIEW

KU$_CONTEXT_VIEW

KU$_CREDENTIAL_VIEW

KU$_DBLINK_VIEW

KU$_DEFROLE_VIEW

KU$_DEPTABLE_OBJNUM_VIEW

KU$_DEPTYPES_VIEW

KU$_DEPVIEWS_VIEW

KU$_DIMENSION_VIEW

KU$_DIRECTORY_VIEW

KU$_DOMIDX_OBJNUM_VIEW

KU$_EDITION_PROC_EXISTS_VIEW

KU$_EDITION_TRIG_EXISTS_VIEW

KU$_END_PLUGTS_BLK_VIEW

KU$_EQNTABLE_DATA_VIEW

KU$_EXP_PKG_BODY_VIEW

KU$_EXP_TYPE_BODY_VIEW

KU$_EXP_XMLSCHEMA_VIEW

KU$_FGA_POLICY_VIEW

KU$_FHTABLE_VIEW

KU$_FIND_ATTRCOL_VIEW

KU$_FIND_HIDDEN_CONS_VIEW

KU$_FIND_NTAB_ATTRCOL_VIEW

KU$_FIND_SGCOL_VIEW

KU$_FIND_SGC_VIEW

KU$_FULL_PKG_VIEW

KU$_FULL_TYPE_VIEW

KU$_HTABLE_DATA_VIEW

KU$_HTABLE_VIEW

KU$_HTPART_DATA_VIEW

KU$_HTSPART_DATA_VIEW

KU$_IDCOL_SEQ_VIEW

KU$_IDENTITY_COLOBJ_VIEW

KU$_INC_TYPE_VIEW

KU$_INDEXTYPE_VIEW

KU$_IND_EXISTS_VIEW

KU$_IND_STATS_VIEW

KU$_IND_SUBNAME_VIEW

KU$_IND_TS_VIEW

KU$_INSTANCE_CALLOUT_VIEW

KU$_IOTABLE_DATA_VIEW

KU$_IOTABLE_VIEW

KU$_IOTPART_DATA_VIEW

KU$_JAVA_CLASS_VIEW

KU$_JAVA_OBJNUM_VIEW

KU$_JAVA_RESOURCE_VIEW

KU$_JAVA_SOURCE_VIEW

KU$_LIBRARY_VIEW

KU$_MONITOR_VIEW

KU$_MVLPROP_VIEW

KU$_MVL_TS_VIEW

KU$_MVPROP_VIEW

KU$_MV_DEPTBL_OBJNUM_VIEW

KU$_MV_TS_VIEW

KU$_MZPROP_VIEW

KU$_M_VIEW_FH_VIEW

KU$_M_VIEW_H_VIEW

KU$_M_VIEW_IOT_VIEW

KU$_M_VIEW_LOG_FH_VIEW

KU$_M_VIEW_LOG_H_VIEW

KU$_M_VIEW_LOG_PFH_VIEW

KU$_M_VIEW_LOG_PH_VIEW

KU$_M_VIEW_PFH_VIEW

KU$_M_VIEW_PH_VIEW

KU$_M_VIEW_PIOT_VIEW

KU$_M_ZONEMAP_FH_VIEW

KU$_M_ZONEMAP_H_VIEW

KU$_M_ZONEMAP_IOT_VIEW

KU$_M_ZONEMAP_PFH_VIEW

KU$_M_ZONEMAP_PH_VIEW

KU$_M_ZONEMAP_PIOT_VIEW

KU$_NIOTABLE_DATA_VIEW

KU$_NTABLE_DATA_VIEW

KU$_NTABLE_OBJNUM_VIEW

KU$_OBJECT_ERROR_VIEW

KU$_OBJECT_STATUS_VIEW

KU$_OBJGRANT_EXISTS_VIEW

KU$_OBJGRANT_VIEW

KU$_OBJPKG_VIEW

KU$_ON_USER_GRANT_VIEW

KU$_OPERATOR_VIEW

KU$_OUTLINE_VIEW

KU$_PARTITION_EST_VIEW

KU$_PART_COL_NAMES_VIEW

KU$_PFHTABLE_VIEW

KU$_PHTABLE_VIEW

KU$_PIOTABLE_VIEW

KU$_PLUGTS_BEGIN_VIEW

KU$_PLUGTS_BLK_VIEW

KU$_PLUGTS_CHECKPL_VIEW

KU$_PLUGTS_TSNAME_FULL_VIEW

KU$_PLUGTS_TSNAME_INDEXP_VIEW

KU$_PLUGTS_TSNAME_INDEX_VIEW

KU$_PLUGTS_TSNAME_TABLE_VIEW

KU$_PLUGTS_TSNAME_VIEW

KU$_POST_DATA_TABLE_VIEW

KU$_PROCACT_INSTANCE_VIEW

KU$_PROCACT_SCHEMA_VIEW

KU$_PROCDEPOBJ_AUDIT_VIEW

KU$_PROCDEPOBJ_GRANT_VIEW

KU$_PROCDEPOBJ_VIEW

KU$_PROCOBJACT_VIEW

KU$_PROCOBJ_AUDIT_VIEW

KU$_PROCOBJ_GRANT_VIEW

KU$_PROCOBJ_OBJNUM_VIEW

KU$_PROCOBJ_VIEW

KU$_PROC_EXISTS_VIEW

KU$_PROFILE_VIEW

KU$_PROXY_VIEW

KU$_REFGROUP_VIEW

KU$_REFPAR_LEVEL

KU$_REF_CONSTRAINT_EXISTS_VIEW

KU$_REF_CONSTRAINT_VIEW

KU$_RLS_CONTEXT_VIEW

KU$_RLS_GROUP_VIEW

KU$_RLS_POLICY_OBJNUM_VIEW

KU$_RLS_POLICY_VIEW

KU$_ROGRANT_VIEW

KU$_ROLE_VIEW

KU$_ROLLBACK_VIEW

KU$_SCHEMA_CALLOUT_VIEW

KU$_SEQUENCE_VIEW

KU$_SEQ_IN_DEFAULT_VIEW

KU$_STRMTABLE_VIEW

KU$_SUBPARTITION_EST_VIEW

KU$_SWITCH_COMPILER_VIEW

KU$_SYNONYM_VIEW

KU$_SYN_EXISTS_VIEW

KU$_SYSGRANT_VIEW

KU$_TABCLST_VIEW

KU$_TABLESPACE_VIEW

KU$_TABLE_EST_VIEW

KU$_TABLE_EXISTS_VIEW

KU$_TABLE_OBJNUM_VIEW

KU$_TABPROP_VIEW

KU$_TAB_STATS_VIEW

KU$_TAB_SUBNAME_VIEW

KU$_TAB_TS_VIEW

KU$_TBS_ILM_POLICY_VIEW

KU$_TRIGGER_VIEW

KU$_TRIG_EXISTS_VIEW

KU$_TRLINK_VIEW

KU$_TSQUOTA_VIEW

KU$_TYPE_BODY_VIEW

KU$_TYPE_VIEW

KU$_USER_BASE_VIEW

KU$_USER_PREF_STATS_VIEW

KU$_VIEWPROP_VIEW

KU$_VIEW_EXISTS_VIEW

KU$_VIEW_OBJNUM_VIEW

KU$_VIEW_STATUS_VIEW

KU$_VIEW_VIEW

KU$_XDB_NTABLE_OBJNUM_VIEW

KU$_XMLSCHEMA_VIEW

KU$_XSACL_VIEW

KU$_XSNSPACE_VIEW

KU$_XSPOLICY_VIEW

KU$_XSRLS_POLICY_VIEW

KU$_XSSCLASS_VIEW

KU$_ZM_VIEW_FH_VIEW

KU$_ZM_VIEW_H_VIEW

KU$_ZM_VIEW_IOT_VIEW

KU$_ZM_VIEW_PFH_VIEW

KU$_ZM_VIEW_PH_VIEW

KU$_ZM_VIEW_PIOT_VIEW