Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Unanswered: java.io.FilePermission

    Able to set permissions for a named file, eg

    call dbms_java.grant_permission('PUBLIC','java.io.FileP ermission','/usr/tmp/blah.txt','read,write,delete')

    - File write is ok.


    ...but unable to use wildcard

    call dbms_java.grant_permission('PUBLIC','java.io.FileP ermission','/usr/tmp/*','read,write,delete')

    No errors when submitting the above, just when writing to file - tells me java.io.Filepermission has not been granted.

    Have tried '-' and '+', but with no success.

    Have seen similar post from some time ago but proposed solution did not look relevant.

    Any thoughts?

    Andrew.

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    call dbms_java.grant_permission('PUBLIC','java.io.FileP ermission','/usr/tmp/*','read,write,delete')

    try adding an extension as well in the form of .*
    ex.
    call dbms_java.grant_permission('PUBLIC','java.io.FileP ermission','/usr/tmp/*.*','read,write,delete')

  3. #3
    Join Date
    Dec 2003
    Posts
    3
    Thanks for the response - a cunning suggestion, but unfortunately not cunning enough!

    Any other ideas?

    Andrew.

  4. #4
    Join Date
    Dec 2003
    Posts
    3
    Further info:

    Have also tried

    exec DBMS_JAVA.GRANT_PERMISSION ( 'PUBLIC', 'SYS:java.lang.RuntimePermission','readFileDescrip tor', '*')

    exec DBMS_JAVA.GRANT_PERMISSION ( 'PUBLIC','SYS:java.lang.RuntimePermission','writeF ileDescriptor','*')

    exec DBMS_JAVA.GRANT_PERMISSION ( 'PUBLIC','SYS:java.lang.RuntimePermission','delete FileDescriptor','*')

    but to no avail. Tried the above with NULL instead of the asterisk too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •