I discovered the answer to this myself - sorry for bothering
y'all.
The answer is 'No'
--
jeremy
"Jeremy Ovenden" <newsposter_at_hazelweb.co.uk> wrote in message
news:adqhri$1entn$1_at_ID-140241.news.dfncis.de...
> Oracle 8.1.6 on Solaris 2.7
>
> Assume we have
>
> PL/SQL stored proc calling Java stored proc which invokes a
> shell script on the server.
>
> I have implemented this and it works.
>
> In order to be able to call the shell script, let's call it
> file.sh, we have to grant privileges like this:
>
> begin
> dbms_java.grant_permission
> ('WD',
> 'java.io.FilePermission',
> '/apps/cgi/bin/file.sh',
> 'execute');
> end;
>
> Do we need to use dbms_java.grant_permission to grant explicit
> privileges on any files that file.sh wishes to execute as
well?
>
> --
>
> Jeremy Ovenden
>
>
>
Received on Fri Jun 07 2002 - 11:25:04 CDT
