From: hrbek at plz.comstar.cz (Ing. Filip Hrbek)
Date: Sun, 6 Feb 2005 17:18:44 +0100
Subject: [Pljava-dev] Re: PL Java Security (sqlj / owner postgres)
Message-ID: <7f8505697a91bdeed3b0889c17f2000e@cnet.pha.comstar.cz>


<BR>> Filip,
<BR>> > SQLJ Schema security:
<BR>> > -----------------------------------
<BR>> > The SQLJ schema is authorized to user
postgres.
<BR>> >
<BR>> Why? In my installation, I don\'t have a
postgres user. Is \"postgres\" a
<BR>> non-superuser in your setup?
<BR>
<BR>Yes, you are right. There is no reason to have
a \"postgres\" user. I am just used to have it as
a default (and the only) superuser.
<BR>
<BR>I wrote the \"checkIfConnectedAsSuperuser\"
method in the source (I can see it already in CVS
:-), this check should be sufficient. The SQLJ
schema and its object can be owned by another
supersuser who is deploying pl/Java, not only by
the default \"postgres\" user. The only important
thing is that the SQLJ objects owner has the
superuser flag \"on\".
<BR>
<BR>Regards, Filip
<BR>
<BR>> 
<BR>> Regards,
<BR>> Thomas Hallgren

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050206/44358107/attachment.html>