postgresql - Error: java.lang.SecurityException: execute on /home/<user>/test.sh JAR file trying to read shell file (Pljava) -


i trying call pl/sql function calls java class , reads shell file , execute same. placed shell file in home directory.

i created jar using class , installed in postgresql.

however, when trying execute in pljava, returns following error:

error: java.lang.securityexception: execute on /home//test.sh

********** error **********

error: java.lang.securityexception: execute on /home//test.sh
sql state: xx000

how solve this?

you cannot read , execute files trusted pl/java. have use untrusted language (i.e. javau), , have create function under superuser


Comments

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

html - Missing border-right in select on Firefox -

python - build a suggestions list using fuzzywuzzy -