From: Alvaro Herrera <alvherre@commandprompt.com>
To: Donald Fraser <postgres@kiwi-fraser.net>
Cc: [ADMIN] <pgsql-admin@postgresql.org>
Subject: Re: WITH SYSID feature dropped
Date: Tue, 20 Dec 2005 14:03:46 -0300
Message-ID: <20051220170345.GB11637@surnet.cl> (raw)
In-Reply-To: <012201c60583$4a832080$0264a8c0@demolish1>
References: <011501c60578$47642e40$0264a8c0@demolish1>
<29845.1135094224@sss.pgh.pa.us>
<012201c60583$4a832080$0264a8c0@demolish1>
Donald Fraser wrote:
> We developed and have been using since 7.1, and currently running 7.4,
> bespoke client / database software. The ability to manage users and security
> was of high priority and we therefore developed a much more elaborate user
> definition where by the information about users was held in our own tables
> and we could create a postgresql database user from this table at any time.
> To simplify things we controlled the SYSID and used this as the key for
> mapping a postgresql user to a user defined in our table.
Why not do it the other way around? Create the Postgres user first,
grab its Oid, then use that as primary key in your user table.
On the other hand, it's possible that the new role management in 8.1,
which has brought much more elaborate privilege handling, could have
rendered your user handling unnecessary. Have you considered exploring
that?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, postgres@kiwi-fraser.net
Subject: Re: WITH SYSID feature dropped
In-Reply-To: <20051220170345.GB11637@surnet.cl>
References: <011501c60578$47642e40$0264a8c0@demolish1> <29845.1135094224@sss.pgh.pa.us> <012201c60583$4a832080$0264a8c0@demolish1> <20051220170345.GB11637@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox