Java Execute Permissions

From: Jeremy Ovenden <newsposter_at_hazelweb.co.uk>
Date: Fri, 7 Jun 2002 16:00:55 +0100
Message-ID: <adqhri$1entn$1@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 - 10:00:55 CDT