2 Replies Latest reply on Jan 6, 2005 12:32 PM by James Attard

    dbms_java.grant_permission() help

    3004
      Hi,

      As system I have execute the dbms_java.grant_permission('SCOTT','java.io.FilePermission','/tmp/ls.txt','read,write,execute') which went through fine.

      In the java procedure I am trying to access the /tmp/ls.txt file. When I execute the procedure I am getting the following error.

      java.security.AccessControlException: the Permission (java.io.FilePermission
      <<ALL FILES>> execute) has not been granted by dbms_java.grant_permission to
      SchemaProtectionDomain(SCOTT|PolicyTableProxy(SCOTT))
      at java.security.AccessControlContext.checkPermission(AccessControlContext.java)
      at java.security.AccessController.checkPermission(AccessController.java)
      at java.lang.SecurityManager.checkPermission(SecurityManager.java)
      at
      oracle.aurora.rdbms.SecurityManagerImpl.checkPermission(SecurityManagerImpl.java
      )
      at java.lang.SecurityManager.checkExec(SecurityManager.java)
      at java.lang.Runtime.exec(Runtime.java)
      at java.lang.Runtime.exec(Runtime.java)
      at java.lang.Runtime.exec(Runtime.java)
      at lastGenTrigger.afterUpdate(lastGenTrigger.java:21)

      Any help ???


      Thanx in advance
      Guru