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

Re: dangling permission on tables after drop user.

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: dangling permission on tables after drop user.
Date: 2004-09-30 13:32:30
Message-ID: 2DCB8064-12E5-11D9-B455-000A9578CFCC@kcilink.com (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

Responses

pgsql-general by date

Next:From: Alvaro HerreraDate: 2004-09-30 14:01:04
Subject: Re: 7.3.4 vacuum/analyze error
Previous:From: Campano, TroyDate: 2004-09-30 12:13:04
Subject: Re: WinXP + PgSQL 8 beta3 = impossible?

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