The DBMS_JAVA.ENABLE_PERMISSION statement is used to enable specified Java permission records based on the primary key in the permission records.
Note
This subprogram is available starting with OceanBase Database V4.4.2 and V4.6.1.
Syntax
DBMS_JAVA.ENABLE_PERMISSION(IN key BIGINT);
Parameters
Parameter |
Note |
|---|---|
| key | The primary key of the permission record to be enabled, which is returned when granting or restricting permissions.keyValue. |
Usage instructions
- Before calling
DBMS_JAVA.ENABLE_PERMISSION, ensure that the tenant parameterob_enable_java_udfis enabled. Otherwise, an unsupported error will be returned. - Only the root user in MySQL-compatible mode can operate Java permissions. Other users will receive an error indicating insufficient permissions when calling these methods.
- This subprogram can re-enable a privilege that has been disabled by
DBMS_JAVA.DISABLE_PERMISSION.