Oracle教程 2023-04-05

Oracle 视图 ALL_SEC_RELEVANT_COLS 官方解释，作用，如何使用详细说明

Oracle视图 ALL_SEC_RELEVANT_COLS 表示 Oracle 数据库中所有的安全相关的列。这个视图能够帮助用户识别哪些列被用来表明表或视图的安全有关标记，以及它们的列属性。

该视图的使用示例如下：

SELECT table_name , column_name
FROM all_sec_relevant_cols
WHERE column_name = ‘SALARY’；

该语句会查询出表中名称为 SALARY 的列的属性，包括它是否为安全有关标记列。

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	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`)
`INHERITED`	`VARCHAR2(3)`	Indicates whether the policy security relevant column is inherited from the root (`YES`) or not (`NO`)