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

javascript - Can Piwik report referrer in real time? -

asp.net - Google Drive Access: At least one client secrets (Installed or Web) should be set -

excel vba add hyperlink to shape in group -