From: Vivek Khera <vivek@khera.org>
To: pgsql-sql@postgresql.org
Subject: Re: sysid
Date: Fri, 25 Nov 2005 22:22:38 -0500
Message-ID: <8F8824BE-4B24-42CB-9499-CE2A2FF3DA58@khera.org> (raw)
In-Reply-To: <20051123154522.GC26927@surnet.cl>
References: <43847C29.8050800@lake-lotawana.mo.us>
<20051123154522.GC26927@surnet.cl>
On Nov 23, 2005, at 10:45 AM, Alvaro Herrera wrote:
> A. R. Van Hook wrote:
>> It seems that in 8.1.0 we can no longer set the SYSID when adding
>> users
>> and groups.
>> i.e
>> template1=# create role hooker sysid 1345;
>> NOTICE: SYSID can no longer be specified
>>
>> I have lots of code that depends on the actual group and user number.
>> Is there a way to set the user and group number?
>
> No -- fix the code. Just curious, how can user code depend on the
> SYSIDs? I don't see a way.
>
If 8.1 doesn't allow you to remove a user who still has rights
granted, then this should be no problem. however, in older versions
you can delete users and leave dangling rights with no way to revoke
them unless you create a user with that specific ID and then revoke
the rights, and re-delete the user.
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: pgsql-sql@postgresql.org
Cc: vivek@khera.org
Subject: Re: sysid
In-Reply-To: <8F8824BE-4B24-42CB-9499-CE2A2FF3DA58@khera.org>
* 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