Note
This view is available starting with V2.2.30.
Purpose
This view displays the profile files and their parameters of the current user.
Applicability
This view applies only to OceanBase Database in Oracle 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 resource parameter. |
| RESOURCE_TYPE | VARCHAR2(8) | NO | The type of the resource parameter. Valid values: <ul><li>KERNEL</li> <li>PASSWORD` |
| LIMIT_ON_RESOURCE | VARCHAR2(40) | NO | The limit value of the resource parameter. |
Sample query
Query the profile files and their parameters of 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
View all profile files and their parameters in the current tenant: DBA_PROFILES
For more information about how to create profile files and the parameters in the profile files, see CREATE PROFILE.
For more information about how to control the login verification strategy of a user by using a profile file, see Login failure handling strategy.