5.351 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.