Skip to Main Content
Forums

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_java.grant_permission not working

V PJSFeb 21 2017 — edited Apr 4 2017

Hi,

I am getting below error while running some java in m function in Oracle 12c

Java Error: 4: java.security.AccessControlException: the Permission (java.io.FilePermission /cloudfs/tmp/aaa_shipping_data/PT0000025442.txt read) has not been granted to AAA. The PL/SQL to grant this is dbms_java.grant_permission( 'AAA', 'SYS:java.io.FilePermission', '/cloudfs/tmp/aaa_shipping_data/123.txt', 'read' )

even though I had already execute dbms_java.grant_permission( 'AAA', 'SYS:java.io.FilePermission', '/cloudfs/tmp/aaa_shipping_data/123.txt', 'read' ),

and the view DBA_JAVA_POLICY show the grantee AAA had the java.io.FilePermission in the /cloudfs/tmp/aaa_shipping_data folder,

but the error still prompt.

Do I miss out some step?

Rgdfs

Vincent
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2017
Added on Feb 21 2017
8 comments
38,009 views