agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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


<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;

view thread (2+ messages)  latest in thread

Message-ID: <7f8505697a91bdeed3b0889c17f2000e@cnet.pha.comstar.cz>
Permalink:  ../7f8505697a91bdeed3b0889c17f2000e@cnet.pha.comstar.cz/
Also on:    postgresql.org/message-id/7f8505697a91bdeed3b0889c17f2000e@cnet.pha.comstar.cz

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Re: PL Java Security (sqlj / owner postgres)
  In-Reply-To: <7f8505697a91bdeed3b0889c17f2000e@cnet.pha.comstar.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox