From: thhal at mailblocks.com (Thomas Hallgren)
Date: Thu, 16 Dec 2004 08:35:56 +0100
Subject: [Pljava-dev] ERROR: must be superuser to
	examine	"dynamic_library_path"
In-Reply-To: 
 <CC1CF380F4D70844B01D45982E671B2348E4B6@mtxexch01.add0.masergy.com>
References: 
 <CC1CF380F4D70844B01D45982E671B2348E4B6@mtxexch01.add0.masergy.com>
	<41C13ADC.6080703@mailblocks.com>
	<thhal-0X9OcAj8ccS4kBUVk8dE3oIkjSevxKP@mailblocks.com>
Message-ID: <thhal-0YNOcAkEccS4tzbeLps9Kn/rvUwzyAC@mailblocks.com>

   Guy,

>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?
>  
>
I'm afraid that you've encountered a bug. It will be fairly easy to fix 
since the code that attempts the access is obsolete. I should have 
removed it long ago. Thanks for pointing this out. I'll supply a patch 
for it later this week.

If you have the source for the latest beta and know how to compile, you 
can comment out the lines 368 and 370 in src/C/pljava/type/Backend.c. 
That should fix the problem.

Regards,
Thomas Hallgren