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

PROFILE_NAME

VARCHAR2(128)

NOT NULL

Name of the lockdown profile

RULE_TYPE

VARCHAR2(128)

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

VARCHAR2(128)

Rule to be enabled or disabled

CLAUSE

VARCHAR2(128)

Clause of the statement

CLAUSE_OPTION

VARCHAR2(128)

Option of the clause

OPTION_VALUE

VARCHAR2(4000)

Value of the option

MIN_VALUE

VARCHAR2(4000)

Minimum value allowed for the option

MAX_VALUE

VARCHAR2(4000)

Maximum value allowed for the option

LIST

VARCHAR2(4000)

List of allowed values for the option

STATUS

VARCHAR2(7)

Status of the lockdown profile:

  • ENABLE

  • DISABLE

  • EMPTY

USERS

VARCHAR2(6)

User type. Possible values:

  • COMMON

  • LOCAL

  • ALL

EXCEPT_USERS

CLOB

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


数据运维技术 » Oracle 视图 DBA_LOCKDOWN_PROFILES 官方解释,作用,如何使用详细说明