DBA_LOCKDOWN_PROFILES

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_USERS`^Foot 1	`CLOB`		For internal use only

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