Note
This view is available starting with V4.4.2 BP1.
Purpose
The DBA_JAVA_POLICY view is used to display the details of Java UDF permissions for DBAs.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| KIND | varchar2(8) | NO | Permission type |
| GRANTEE | varchar2(128) | NO | Username granted the permission |
| TYPE_SCHEMA | varchar2(128) | YES | Schema where the permission type is located |
| TYPE_NAME | varchar2(4096) | YES | Permission type name |
| NAME | varchar2(4096) | YES | Permission name |
| ACTION | varchar2(4096) | YES | Specific permission |
| ENABLED | varchar2(8) | NO | Whether the permission is currently active |
| SEQ | NUMBER(38) | NO | Corresponds to the key column in java_policy |
Sample query
Query the details of Java UDF permissions in the current Oracle tenant.
obclient> SELECT * FROM DBA_JAVA_POLICY;