Re: dangling permission on tables after drop user.

From: Richard Huxton <dev(at)archonet(dot)com>
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 20:55:14
Message-ID: 415B2132.3030209@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2004-09-29 21:07:38 Re: dangling permission on tables after drop user.
Previous Message Vivek Khera 2004-09-29 20:24:11 dangling permission on tables after drop user.