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
Post a Comment