3.69 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

COMMONFoot 1

VARCHAR2(3)

Indicates whether the policy security relevant column is applied and enforced in all application PDBs (YES) or only in the local PDB (NO)

INHERITEDFootref 1

VARCHAR2(3)

Indicates whether the policy security relevant column is inherited from the root (YES) or not (NO)

Footnote 1

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).