Postgres Pro
Downloads
Home   >   mailing lists

Re: dangling permission on tables after drop user. - Mailing list pgsql-general

From Richard Huxton
Subject Re: dangling permission on tables after drop user.
Date
Msg-id 415B2132.3030209@archonet.com
Whole thread Raw
In response to dangling permission on tables after drop user.  (Vivek Khera <khera@kcilink.com>)
Responses Re: dangling permission on tables after drop user.  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
Tree view 
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" ?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: dangling permission on tables after drop user.
Next
From: Vivek Khera
Date:
Subject: Re: dangling permission on tables after drop user.