Skip site navigation (1) Skip section navigation (2)

Re: WITH SYSID feature dropped

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Donald Fraser <postgres(at)kiwi-fraser(dot)net>
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WITH SYSID feature dropped
Date: 2005-12-20 17:03:46
Message-ID: 20051220170345.GB11637@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: ljbDate: 2005-12-21 01:42:14
Subject: Users + Groups = Roles, duplicate name issue
Previous:From: Tom LaneDate: 2005-12-20 16:59:49
Subject: Re: WITH SYSID feature dropped

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group