Technote

goal: How to delete java permission from the database using dbms_java.

delete_permission

fact: Oracle Server - Enterprise Edition

fact: Java







fix:



In order to remove a Java permission from the database, it must first be 

disabled using the dbms_java.revoke_permission procedure.  You can then use the 

DELETE_PERMISSION procedure of the DBMS_JAVA package to remove or DROP a 

particular permission from the database.  This is done on the basis of a key 

number which is equivalent to the SEQ column of the DBMS_JAVA_POLICY table.



Example: 



SQL>connect system/manager@ora817



SQL> col  TYPE_NAME format a28 

SQL> col  NAME format a10 

SQL> col  action format a8 

SQL> execute dbms_java.grant_permission ('SCOTT', 'java.io.FilePermission',

'c:temp', 'read');



PL/SQL procedure successfully completed.



SQL> select type_name, name, action, enabled, seq from dba_java_policy where 

grantee='SCOTT';



TYPE_NAME                    NAME       ACTION   ENABLED         SEQ

---------------------------- ---------- -------- -------- ----------

java.io.FilePermission       c:temp    read     ENABLED          62



SQL> execute dbms_java.revoke_permission ('SCOTT', 'java.io.FilePermission',

'c:temp', 'read');



PL/SQL procedure successfully completed.



SQL> select type_name, name, action, enabled, seq from dba_java_policy where 

grantee='SCOTT';



TYPE_NAME                    NAME       ACTION   ENABLED         SEQ

---------------------------- ---------- -------- -------- ----------

java.io.FilePermission       c:temp    read     DISABLED         62



SQL> execute dbms_java.delete_permission(62);



PL/SQL procedure successfully completed.



SQL> select type_name, name, action, enabled, seq from dba_java_policy where 

grantee='SCOTT';



no rows selected





Reference: Java Developer¢¯s Guide.