DELETE_PERMISSION

The DBMS_JAVA>Delete_PERMISSION procedure is used to delete a specified Java permission record from the privilege records based on its primary key.

Syntax

DBMS_JAVA.DELETE_PERMISSION(IN key BIGINT);

Parameters

Usage instructions

• Before calling DBMS_JAVA_DELETE_PERMISSION, ensure that the tenant parameter ob_enable_java_udf is 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 privileges when calling them.
• The delete operation permanently removes the permission record. If you only need to temporarily disable it, use DBMS_JAVA.DISABLE_PERMISSION.