Purpose
This view displays all profile files and their parameters in the current tenant.
Applicability
This view is available starting with OceanBase Database.
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 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.