ALL_SEC_RELEVANT_COLS

ALL_SEC_RELEVANT_COLS describes the security relevant columns of the security policies for the tables and views accessible to the current user.

Related Views

  • DBA_SEC_RELEVANT_COLS describes the security relevant columns of all security policies in the database.

  • USER_SEC_RELEVANT_COLS describes the security relevant columns of the security policies for the tables and views owned by the current user. This view does not display the OBJECT_OWNER column.


Column Datatype NULL Description

OBJECT_OWNER

VARCHAR2(128)

 

Owner of the table or view

OBJECT_NAME

VARCHAR2(128)

 

Name of the table or view

POLICY_GROUP

VARCHAR2(128)

 

Name of the policy group

POLICY_NAME

VARCHAR2(128)

 

Name of the policy

SEC_REL_COLUMN

VARCHAR2(128)

 

Name of the security relevant column

COLUMN_OPTION

VARCHAR2(8)

 

Option of the security relevant column:

  • NONE

  • ALL_ROWS