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
about.
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.
+1-301-869-4449 x806