asked on

how using java.io.FilePermission

Hallo,

how can i using java.io.FilePermission to scott allow delete a file on d:\temp\*.* ?

My PL/SQL procedure (a javaClass+Wrapper) is ok. if scott has the javasyspriv role, but by javauserpriv role i occur an error.

Thanks

r_mikhaeel

at your sql+:
=============
login as sys or any other user of the administrator group, and invoke the following grant command:
call dbms_java.grantpermission('SCOTT','java.io.FilePermission','d:\temp\*.*','delete');

note:
=====
you can use execute instead of call,if it does not work.

ASKER CERTIFIED SOLUTION

r_mikhaeel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Moondancer

Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,
Moondancer - EE Moderator

P.S. Please click your Member Profile, expand View Question History to navigate and update all your open and locked questions.

DanRollins

Recommended disposition:

Accept r_mikhaeel's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer

Moondancer

Thanks, Dan.
I finalized this today and will monitor it in the event an adjustment is needed.
Moondancer - EE Moderator