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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F.O'Connell | 2004-09-29 21:45:47 | Index Analysis: Filters |
Previous Message | Vivek Khera | 2004-09-29 21:07:38 | Re: dangling permission on tables after drop user. |