Note
This view is available starting with V4.4.2 BP1.
Purpose
The DBA_JAVA_POLICY view is used to display the current Java UDF permission configuration details to DBAs.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| KIND | varchar(8) | NO | Permission type |
| GRANTEE | varchar(128) | NO | Username granted the permission |
| TYPE_SCHEMA | varchar(128) | NO | Schema where the permission type is located |
| TYPE_NAME | varchar(4096) | YES | Permission type name |
| NAME | varchar(4096) | YES | Permission name |
| ACTION | varchar(4096) | YES | Specific permission |
| ENABLED | varchar(8) | NO | Whether the current permission is enabled |
| SEQ | bigint(20) | NO | Corresponds to the key column in java_policy |
Sample query
Query the Java UDF permission configuration details in the current MySQL tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_JAVA_POLICY;