Note
This view is available starting with V2.2.30.
Purpose
This view displays all Profile files and their parameters that the current user can access.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PROFILE | VARCHAR2(30) | NO | Name of the Profile file |
| RESOURCE_NAME | VARCHAR2(32) | NO | Name of the resource parameter |
| RESOURCE_TYPE | VARCHAR2(8) | NO | Type of the resource parameter. Valid values:
|
| LIMIT_ON_RESOURCE | VARCHAR2(40) | NO | Value of the limit on the resource parameter |
Sample query
Query the information about all Profile files and their parameters that the current user can access.
obclient [SYS]> SELECT * FROM SYS.ALL_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 a Profile file and the parameters in the Profile file, see CREATE PROFILE.
For more information about how to control the login verification strategy for a user by using a Profile file, see Login failure handling strategy.