Drop a user leaves permissions!

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Drop a user leaves permissions!
Date: 2001-02-13 17:09:35
Message-ID: 996802F75C3CD411B424001083FA445B05953D@CET_PONXX_FP001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Mikhail V. Majorov 2001-02-13 17:37:20 How create SQL variable sentense in plpgsql?!
Previous Message David Wall 2001-02-13 17:08:01 Re: Re: ALTER DROP COLUMN