On Sep 29, 2004, at 5:35 PM, Alvaro Herrera wrote:
>>> Am I missing something Vivek, or should the gross hack be "creating a
>>> user with id=102" ?
>> And how exactly does one accomplish this? pg_users is a view so you
>> can't insert into it.
> CREATE USER ... WITH SYSID 102;
Ok. I did that. So now how do I get rid of that user and all the
grants? DROP USER ends up with the dangling GRANTs still hanging
Is there no way to drop a user and have the necessary grants disappear?
How does one drop a user cleanly?
Vivek Khera, Ph.D.
In response to
pgsql-general by date
|Next:||From: Alvaro Herrera||Date: 2004-09-30 14:01:04|
|Subject: Re: 7.3.4 vacuum/analyze error|
|Previous:||From: Campano, Troy||Date: 2004-09-30 12:13:04|
|Subject: Re: WinXP + PgSQL 8 beta3 = impossible?|