DBA_END_USER_SECURITY_CONTEXTS

DBA_END_USER_SECURITY_CONTEXTS displays all Oracle Deep Data Security (Deep Sec) end-user security contexts currently maintained in the database..

Column Datatype NULL Description
USERNAME VARCHAR2(128) NOT NULL User name for the end-user security context
CONTEXT_ID RAW(16) NOT NULL Unique end-user security context identifier
LOOKUP_KEY VARCHAR2(1024)   Lookup key associated with the end-user security context
CREATED_TIME TIMESTAMP(6) WITH TIME ZONE   Creation time of the end-user security context
LAST_ACCESS_TIME TIMESTAMP(6) WITH TIME ZONE   Most recent access time of the end-user security context
INACTIVE_TIMEOUT_MINUTES NUMBER(6)   End-user security context inactivity timeout value (in minutes)
USER_TYPE VARCHAR2(8)  

User type of the end-user security context:

  • EXTERNAL

  • LOCAL

SECURITY_CONTEXT_TYPE VARCHAR2(19)  

Type of the end-user security context:

  • DIRECT_LOGON

  • THROUGH_APPLICATION

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.2.