Note
This view is available starting with V4.4.2 BP1.
Purpose
The USER_JAVA_POLICY view displays the Java UDF permission configurations of the current user.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| KIND | varchar(8) | NO | The type of the permission. |
| GRANTEE | varchar(128) | NO | The username of the user who is granted the permission. |
| TYPE_SCHEMA | varchar(128) | NO | The schema where the permission type is located. |
| TYPE_NAME | varchar(4096) | YES | The name of the permission type. |
| NAME | varchar(4096) | YES | The name of the permission. |
| ACTION | varchar(4096) | YES | The specific permission. |
| ENABLED | varchar(8) | NO | Indicates whether the permission is enabled. |
| SEQ | bigint(20) | NO | The key value in the java_policy view. |
Sample query
Query the Java UDF permission configurations of the current user.
obclient [oceanbase]> SELECT * FROM oceanbase.USER_JAVA_POLICY;