The DBMS_JAVA.DISABLE_PERMISSION procedure is used to disable a specified Java permission record based on its primary key.
Note
This subprogram is available starting with OceanBase Database V4.4.2 and V4.6.1.
Syntax
DBMS_JAVA.DISABLE_PERMISSION(IN key BIGINT);
Parameters
Parameter |
Note |
|---|---|
| key | The primary key of the privilege record to be disabled, which is returned when granting or restricting privileges.keyValue. |
Usage instructions
- Before calling
DBMS_JAVA.DISABLE_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 them.
- Disabled permission records are retained and can be re-enabled using
DBMS_JAVA.ENABLE_PERMISSION.