agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] SecurityException on pljava-1.2
Date: Thu, 02 Mar 2006 07:09:28 +0100
Message-ID: <44068C18.50206@tada.se> (raw)
In-Reply-To: <44062BC3.1050808@nttdata.co.jp>
References: <44062BC3.1050808@nttdata.co.jp>

Satoshi,
You are trying to execute an operating system command. Using a function 
that is declared with 'language java' that will not be permitted since, 
'java' in PostgreSQL terminology is a 'trusted language'. You need to 
declare your function with 'language javaU' (untrusted). Some relevant 
links:

http://gborg.postgresql.org/project/pljava/genpage.php?userguide#Trusted_language
http://www.postgresql.org/docs/8.1/interactive/perm-functions.html
http://www.postgresql.org/docs/8.1/interactive/sql-createlanguage.html

Regards,
Thomas Hallgren

PS.
I see that you're using packages that start with 
'org.postgresql.pljava'. Are you developing something that you plan to 
make part of PL/Java?

Satoshi Nagayasu wrote:
> Hi folks,
>
> When I use pljava-1.0 with PostgreSQL 8.0,
> my java procedures work fine.
>
> However, when I upgrade PG to 8.1, and pljava to 1.2,
> I got the security exception like below:
>
> java.lang.SecurityException: execute on <<ALL FILES>>
>         at org.postgresql.pljava.internal.Backend$1.assertPermission(Backend.java:178)
>         at org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:113)
>         at org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:91)
>         at java.lang.SecurityManager.checkExec(SecurityManager.java:774)
>         at java.lang.Runtime.exec(Runtime.java:563)
>         at java.lang.Runtime.exec(Runtime.java:428)
>         at java.lang.Runtime.exec(Runtime.java:364)
>         at org.postgresql.pljava.restore.Command.execCommand(Command.java:27)
>         at org.postgresql.pljava.restore.RestoreDB.execRestore(RestoreDB.java:33)
>
> I guess this is a kind of FAQ, but I can't find any information on the net.
> How can I fix this?
>
> Regards,
>   

view thread (3+ messages)  latest in thread

Message-ID: <44068C18.50206@tada.se>
Permalink:  ../44068C18.50206@tada.se/
Also on:    postgresql.org/message-id/44068C18.50206@tada.se

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] SecurityException on pljava-1.2
  In-Reply-To: <44068C18.50206@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox