Re: bug in permission handling?

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martin Renters <martin(at)datafax(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bug in permission handling?
Date: 2002-01-15 02:44:04
Message-ID: 3.0.5.32.20020115104404.011ea100@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 10:29 AM 14-01-2002 -0500, Tom Lane wrote:
>Martin Renters <martin(at)datafax(dot)com> writes:
>> Should the permissions of a deleted user get assigned to a new user
>> as in the example below?
>
>That can happen, since the default "usesysid" assignment is "max
>existing usesysid + 1". If you delete the last user then their sysid
>becomes a candidate for reassignment. This is not real good, but fixing
>it isn't that high on the priority list (and is difficult to do unless
>we take away the option of hand-assigned sysids ... otherwise we could
>just have a sequence generator for sysids).

I think the sequence way is good for now - don't reuse user ids. However
what's the max possible user id?

Also that way if someone screws up and deletes the wrong user, it might
still be possible to restore the user and permissions.

Cheerio,
Link.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-15 02:49:49 Re: Theory about XLogFlush startup failures
Previous Message Brent Verner 2002-01-15 02:30:38 Re: Problem reloading regression database