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

Re: BUG #1161: User permissions are kept, even if user is

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martin <martin(at)4finger(dot)net>,PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1161: User permissions are kept, even if user is
Date: 2004-06-09 08:24:21
Message-ID: Pine.LNX.4.60.0406091006400.23621@sablons.cri.ensmp.fr (view raw or flat)
Thread:
Lists: pgsql-bugs
Dear Tom,

> The "clean" way to handle this would be to extend the bootstrap command
> parser to accept a command along the lines of CREATE [SHARED] SEQUENCE
> and then add a file in src/include/catalog that defines the shared
> user-id-generator sequence.  (Look at how pg_shadow is created for
> precedent.)

Ok. I'll look into that to evaluate what is the impact.

> Not having looked recently, I have no idea how much pain is implied by
> the preceding paragraph ;-).  I'd be willing to accept cruder
> compromises if that approach seems impractical, but please look to see
> if it can be done nicely first.

Ok.

For crude stuff, I can contribute simple and efficient ideas:

I was thinking that any integer attribute of any tuple in a shared 
relation would be ok to store a sequence value. There are only 3 shared 
relations, pg_{database,group,shadow}. Thus, something like a speudo 
"next_sysid" user/group could store the next value in the relevant shared 
relations.

This approach would be light weight from the implementation point of view. 
Not very clean, but that would be easy and would not change much the 
catalog.

-- 
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-06-09 13:34:19
Subject: Re: BUG #1161: User permissions are kept, even if user is
Previous:From: Tom LaneDate: 2004-06-09 04:38:13
Subject: Re: BUG #1161: User permissions are kept, even if user is

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