Oracle 视图 DBA_LOCKDOWN_PROFILES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图 DBA_LOCKDOWN_PROFILES 也称作枷锁等级概要，是Oracle数据库用来查询和管理锁定级别的控制视图，当用户登录数据库时，基于用户的角色特性和其他信息，系统会自动为其分配一个枷锁等级。
使用方法：
1.查看当前的枷锁等级：
Select * from dba_lockdown_profiles;
2.设置新的枷锁等级：
Alter system set lockdown_level = 5 scope = both;
3.重置枷锁等级：
Alter system reset lockdown_level scope = both;
官方英文解释
DBA_LOCKDOWN_PROFILES provides information about lockdown profiles.
The PRIVATE_DBAAS, PUBLIC_DBAAS, and SAAS lockdown profiles are empty placeholder profiles for the lockdown profiles of their corresponding deployment type. You can modify and add restrictions to these profiles based on their deployment purpose. For example, if you have a Software as a Service (SAAS) application, you can modify the SAAS lockdown profile and use it. You can also delete and re-create these profiles.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the lockdown profile |
|
|
|
Rule type. A lockdown profile is used to restrict operations that can be performed by users connected to a given PDB. It provides the ability to add or remove different types of rules like STATEMENT, FEATURES or OPTIONS which will be restricted in the PDB. |
|
|
|
|
Rule to be enabled or disabled |
|
|
|
|
Clause of the statement |
|
|
|
|
Option of the clause |
|
|
|
|
Value of the option |
|
|
|
|
Minimum value allowed for the option |
|
|
|
|
Maximum value allowed for the option |
|
|
|
|
List of allowed values for the option |
|
|
|
|
Status of the lockdown profile:
|
|
|
|
|
User type. Possible values:
|
|
|
|
|
For internal use only |
See Also:
-
“PDB_LOCKDOWN”
-
Oracle Multitenant
Administrator’s Guide for an introduction to PDB lockdown profiles -
Oracle Database SQL
Language Reference for more information about creating lockdown profiles -
Oracle Database SQL
Language Reference for more information about dropping lockdown profiles -
Oracle Database SQL
Language Reference for more information about altering lockdown profiles
