3.209 ALL_END_USER_CONTEXT_DEFINITIONS

ALL_END_USER_CONTEXT_DEFINITIONS displays Oracle Deep Data Security (Deep Sec) end-user contexts that are accessible to the current user.

This view displays end-user contexts owned by the current user. If the current user has the SELECT ANY END USER CONTEXT system privilege, then this view displays all end-user contexts in the database.

Related Views

  • DBA_END_USER_CONTEXT_DEFINITIONS displays all Deep Sec end-user contexts defined in the database.

  • USER_END_USER_CONTEXT_DEFINITIONS displays Deep Sec end-user contexts that are owned by the current user. This view does not display the CONTEXT_OWNER column.

Column Datatype NULL Description

CONTEXT_OWNER

VARCHAR2(128)

NOT NULL

Owner of the end-user context

CONTEXT_NAME

VARCHAR2(128)

NOT NULL

Name of the end-user context

HANDLER_OWNER

VARCHAR2(128)

Schema of the context-handler function

HANDLER_PACKAGE

VARCHAR2(128)

Package containing the context-handler function

HANDLER_PROCEDURE

VARCHAR2(128)

Name of the context-handler function

HANDLER_STATUS

VARCHAR2(7)

Indicates whether the context-handler function is VALID or INVALID

JSON_SCHEMA

JSON

Schema definition for the JSON payload

Note:

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