Drop a user leaves permissions! - Mailing list pgsql-general

From Trewern, Ben
Subject Drop a user leaves permissions!
Date
Msg-id 996802F75C3CD411B424001083FA445B05953D@CET_PONXX_FP001
Whole thread Raw
List pgsql-general
I'm using PostgreSQL and I've been working with permissions.
I've tried the following:

CREATE USER ben;
GRANT ALL ON table1 TO ben;
DROP USER ben;

The permissions get left to the table as in :

     Relation    |      Access permissions
------------------------------------------------------
table1            | {"=","51=arwR"}

I assume that 51 is the ID of the user who was dropped.
Is this a bug?  How should I clean up the permissions?

thanks

Ben

pgsql-general by date:

Previous
From: "Brent R. Matzelle"
Date:
Subject: Re: ALTER DROP COLUMN
Next
From: Anand Raman
Date:
Subject: Re: [araman@india-today.com: locking problem with JDBC (suspicion)]