Newbie alert. First, thanks Thomas for this great addition to
PostgreSQL - I appreciate your efforts. I've installed PLJava on Linux
PostgreSQL 8.0 in a little test database. As the "postgres" super user,
I am able to deploy, load examples.jar and run javatest stored
functions. I did not need to set the dynamic_library_path in
postgresql.conf, as the so's where installed in /usr/local/pgsql/lib,
where it apparently already looking.
I've granted "All" to "public" on both the sqlj and javatest schemas.
But whenever I try to run any javatest functions as a user other than
postgres, I get the subject message. Is it possible to configure this
so that I don't need to grant superuser privilege to every user that
wants to execute Java stored procedures?
--
Guy Rouillier