Note
This view is available starting with V2.2.30.
Purpose
This view displays all profile files and their parameters in the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PROFILE | VARCHAR2(30) | NO | The name of the profile file. |
| RESOURCE_NAME | VARCHAR2(32) | NO | The name of the parameter. |
| RESOURCE_TYPE | VARCHAR2(8) | NO | The type of the parameter. Valid values:
|
| LIMIT | VARCHAR2(128) | NO | The limit value of the parameter. |
Sample query
Query all profile files and their parameters in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_PROFILES;
The query result is as follows:
+----------+--------------------------+---------------+-----------------+
| PROFILE | RESOURCE_NAME | RESOURCE_TYPE | LIMIT |
+----------+--------------------------+---------------+-----------------+
| DEFAULT | FAILED_LOGIN_ATTEMPTS | PASSWORD | UNLIMITED |
| DEFAULT | PASSWORD_GRACE_TIME | PASSWORD | UNLIMITED |
| DEFAULT | PASSWORD_LIFE_TIME | PASSWORD | UNLIMITED |
| DEFAULT | PASSWORD_LOCK_TIME | PASSWORD | 86400000000 |
| DEFAULT | PASSWORD_VERIFY_FUNCTION | PASSWORD | NULL |
| profile1 | FAILED_LOGIN_ATTEMPTS | PASSWORD | 5 |
| profile1 | PASSWORD_GRACE_TIME | PASSWORD | DEFAULT |
| profile1 | PASSWORD_LIFE_TIME | PASSWORD | 5184000000000 |
| profile1 | PASSWORD_LOCK_TIME | PASSWORD | 86400000000 |
| profile1 | PASSWORD_VERIFY_FUNCTION | PASSWORD | VERIFY_FUNCTION |
+----------+--------------------------+---------------+-----------------+
10 rows in set
References
For information about how to create a profile file and the parameters in the profile file, see CREATE PROFILE.
For information about how to control the login verification strategy of a user by using a profile file, see Login failure handling strategy.