Purpose
This view displays the profile files and their parameters that are owned by the current user.
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 resource parameter. |
| RESOURCE_TYPE | VARCHAR2(8) | NO | The type of the resource parameter.
|
| LIMIT_ON_RESOURCE | VARCHAR2(40) | NO | The limit value of the resource parameter. |
Sample query
Query the profile files and their parameters that are accessible to the current user.
obclient [SYS]> SELECT * FROM SYS.USER_PROFILES;
The query result is as follows:
+----------+---------------+---------------+-------------------+
| PROFILE | RESOURCE_NAME | RESOURCE_TYPE | LIMIT_ON_RESOURCE |
+----------+---------------+---------------+-------------------+
| DEFAULT | NULL | NULL | NULL |
| profile1 | NULL | NULL | NULL |
+----------+---------------+---------------+-------------------+
2 rows in set
References
Query all profile files and their parameters in the current tenant: DBA_PROFILES
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.