Note
This view is available starting with V4.4.2 BP1.
Purpose
The DBA_JAVA_POLICY view displays the current Java UDF permission configuration details to DBAs.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| KIND | varchar(8) | NO | Permission type |
| GRANTEE | varchar(128) | NO | The username that 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 current permission is enabled. |
| SEQ | bigint(20) | NO | Corresponds to the key column in the java_policy table. |
Sample query
Query the current Java UDF permission configuration details.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_JAVA_POLICY;