Oracle教程 2023-04-02

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

Oracle视图V$LOCKDOWN_RULES用以查看数据库安全威胁限制设置的信息。通过它可以确认数据库安全威胁限制是否正确配置，从而提高数据库安全性。

具体而言， V$LOCKDOWN_RULES视图提供如下信息：

1.当前已启用的安全威胁限制的类型（如检查共享内存段，禁用基于进程的安全，禁用环境变量，不允许运行操作系统命令等）

2.当前安全威胁限制规则生效级别

3.当前安全威胁限制规则的详细描述

V$LOCKDOWN_RULES视图可以使用常用的sql语句（如SELECT）从数据库中检索信息：

SQL statement：
SELECT rule_name,rule_action,rule_level, description
FROM v$lockdown_rules;

V$LOCKDOWN_RULES displays information about lockdown profile rules that are applicable in the pluggable database (PDB) where this view is queried.

Column	Datatype	Description
`RULE_TYPE`	`VARCHAR2(128)`	Type of the rule: `STATEMENT` `FEATURE` `OPTION`
`RULE`	`VARCHAR2(128)`	Rule to be enabled or disabled
`CLAUSE`	`VARCHAR2(128)`	Clause of the statement
`CLAUSE_OPTION`	`VARCHAR2(128)`	Option of the clause
`STATUS`	`VARCHAR2(7)`	Status of the lockdown profile: `ENABLE` `DISABLE` `EMPTY`
`USERS`	`VARCHAR2(6)`	Type of users affected by the rule: `ALL` `LOCAL` `COMMON`
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs `1`: This value is used for rows containing data that pertain to only the root. n: Where n is the applicable container ID for the rows containing data