ALL_SEC_RELEVANT_COLS

Previous Next JavaScript must be enabled to correctly display this content

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`
`COMMON`	`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`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`INHERITED`	`VARCHAR2(3)`		Indicates whether the policy security relevant column is inherited from the root (`YES`) or not (`NO`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also: