[GENERAL] Restoring default privileges on a table

2011-12-28 Thread julian
This message has been digitally signed by the sender. _GENERAL__Restoring_default_privileges_on_a_table.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

[GENERAL] Restoring default privileges on a table

2011-12-28 Thread Julian Mehnle
Hi all, I just ran into a long-standing issue with the Pg privileges system. It seems there is no way to restore a table's default privileges to what they were directly after creating the table. `REVOKE ALL ON table …` revokes not only privileges that were explicitly granted using GRANT but also