Note
This view is available starting with V4.4.2 BP1.
Purpose
The USER_JAVA_POLICY view displays details about the current Java UDF permission configurations to the DBA.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| KIND | varchar2(8) | NO | Permission type |
| GRANTEE | varchar2(128) | NO | Username of the user who is granted the permission |
| TYPE_SCHEMA | varchar2(128) | YES | Schema of the permission type |
| TYPE_NAME | varchar2(4096) | YES | Permission type name |
| NAME | varchar2(4096) | YES | Permission name |
| ACTION | varchar2(4096) | YES | Specific permission |
| ENABLED | varchar2(8) | NO | Indicates whether the current permission is active. |
| SEQ | NUMBER(38) | NO | Corresponds to the key column in the java_policy table. |
Sample query
Query the current Java UDF permission configurations for the current user.
obclient> SELECT * FROM USER_JAVA_POLICY;