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

Re: dangling permission on tables after drop user.

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dangling permission on tables after drop user.
Date: 2004-09-29 21:35:58
Message-ID: 20040929213558.GA6199@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, Sep 29, 2004 at 05:07:38PM -0400, Vivek Khera wrote:
> 
> On Sep 29, 2004, at 4:55 PM, Richard Huxton wrote:
> 
> >Vivek Khera wrote:
> >>there is no user with ID 102 in the pg_user view.  pg_restore 
> >>complains about the missing user "102".  And no, the user was not 
> >>"102" it was the name of a (former) employee.
> >
> >>The gross hack is to pg_restore to an ascii file and delete those 
> >>GRANT lines, but the compressed dump is over 2Gb for this database.
> >
> >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;

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Dios hizo a Adán, pero fue Eva quien lo hizo hombre.


In response to

Responses

pgsql-general by date

Next:From: Thomas F.O'ConnellDate: 2004-09-29 21:45:47
Subject: Index Analysis: Filters
Previous:From: Vivek KheraDate: 2004-09-29 21:07:38
Subject: Re: dangling permission on tables after drop user.

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