DROP GROUP leaves permissions a mess ...

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: DROP GROUP leaves permissions a mess ...
Date: 2005-07-25 22:02:37
Message-ID: 20050725185658.C54567@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Using an 8.0.3 database, if I do:

CREATE GROUP testgrp WITH USER pgsql;
GRANT ALL ON timezone TO GROUP testgrp;
DROP GROUP testgrp;

The table permissions still contain the reference to the 'group':

public | timezone | table | {pgsql=arwdRxt/pgsql,"group 100=arwdRxt/pgsql"}

And you can't REVOKE those permissions afterwards:

ams=# REVOKE ALL ON timezone FROM GROUP testgrp;
ERROR: group "testgrp" does not exist
ams=# REVOKE ALL ON timezone FROM GROUP "100";
ERROR: group "100" does not exist

Should there not be an ERROR returned when you try and drop a user/group
that has permissions on a table in the database, to prevent this?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Fuhr 2005-07-25 22:03:58 Re: More buildfarm stuff
Previous Message Jim C. Nasby 2005-07-25 22:02:02 Re: More buildfarm stuff