Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Java stored procedure in oracle

669410Nov 30 2008 — edited Dec 1 2008
Hi,
This is regarding the java stored procedure.
I have written a java stored procedure for mailing from DB.But it required some grants or extra privileges to be run from the data base.
CAn anyone please specify what are the grants needed for this.

I have to give to following permissions to the java methods....

dbms_java.grant_permission(user,'java.util.PropertyPermission','*','read');
dbms_java.grant_permission(user,'java.net.SocketPermission','*','connect, resolve');
dbms_java.grant_permission(user,'java.io.FilePermission',FilePathName,'read');


Can anyone please specify what are the privileges required to run the above.Because I have tired it with normal priviledges..it's not working.....

I am getting the following error while executing this from the normal user..rather the user that have been created for me....

ORA-29532: Java call terminated by uncaught Java exception: java.lang.SecurityException: policy table update SYS:java.util.PropertyPermission, *
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at line 1



Thanks,
Anirban Datta

Edited by: user5815929 on Nov 30, 2008 8:42 PM
This post has been answered by zhxiangxie on Dec 1 2008
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 29 2008
Added on Nov 30 2008
#java, #pl-sql, #procedure
4 comments
6,240 views