dropped users - Mailing list pgsql-general

From Franco Bruno Borghesi
Subject dropped users
Date
Msg-id 200305221839.15950.franco@akyasociados.com.ar
Whole thread Raw
List pgsql-general
Hi all.

I've noticed that permissions granted to a user are kept in the database even after the user has been droped.
When I dump the database, y get the line

GRANT ALL ON TABLE <xxx> TO "106";

where 106 is the value of the usesysid field in pg_user/pg_shadow that belonged to the dropped user.

What is the best way to remove this old permissions from my database? Should I delete them from
any table in the catalag? if this is the case, which table?

Thanks in advance.

pgsql-general by date:

Previous
From: Jules Chalier
Date:
Subject: latin1 -> unicode
Next
From: "Vincent Hikida"
Date:
Subject: Re: plpgsql recursion