5.152 DBA_LOCKDOWN_PROFILES

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_USERSFoot 1

CLOB

For internal use only

Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.

See Also: