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(30)   Owner of the table or view
OBJECT_NAME VARCHAR2(30)   Name of the table or view
POLICY_GROUP VARCHAR2(30)   Name of the policy group
POLICY_NAME VARCHAR2(30)   Name of the policy
SEC_REL_COLUMN VARCHAR2(30)   Name of the security relevant column
COLUMN_OPTION VARCHAR2(8)   Option of the security relevant column:
  • NONE

  • ALL_ROWS