Note
This view is introduced since V5.0.1.
Purpose
The DBA_JAVA_POLICY view displays the Java permission policies of all users in the current tenant, including the permission grant and restriction rules of Java UDFs.
Applicability
This view applies only to OceanBase Database in Oracle-compatible mode.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| KIND | VARCHAR2(8) | NO | The type of the policy:
|
| GRANTEE | VARCHAR2(128) | NO | The name of the authorized user. |
| TYPE_SCHEMA | VARCHAR2(128) | YES | The name of the schema to which the type belongs. |
| TYPE_NAME | VARCHAR2(4096) | YES | The name of the type. |
| NAME | VARCHAR2(4096) | YES | The name of the permission target. |
| ACTION | VARCHAR2(4096) | YES | The permission action. |
| ENABLED | VARCHAR2(8) | NO | Whether the policy is enabled:
|
| SEQ | NUMBER(38) | NO | The sequence number of the policy. |
Query example
After creating a Java permission policy using DBMS_JAVA.GRANT_PERMISSION, query all Java permission policies in the current tenant.
SELECT * FROM SYS.DBA_JAVA_POLICY;
The return result is as follows:
+------+---------+----------------+------------------------+------+--------+---------+------+
| KIND | GRANTEE | TYPE_SCHEMA | TYPE_NAME | NAME | ACTION | ENABLED | SEQ |
+------+---------+----------------+------------------------+------+--------+---------+------+
| GRANT| SYS | java.io | FilePermission | /tmp/-| read | ENABLED | 1 |
+------+---------+----------------+------------------------+------+--------+---------+------+
1 row in set (0.00 sec)
Related views
- USER_JAVA_POLICY: displays the Java permission policies owned by the current user.