bdmyt...@eranet.pl writes: > Cannot revoke column level privilages. AFAICS this is not a bug, and it's certainly not specific to column-level privileges. You had "postgres" grant some privileges to "otherUser" with grant option, and then had "otherUser" re-grant those privileges to public. "postgres" cannot revoke the re-grant directly. You can have it revoke "otherUser"'s grant option. (I think this will require the CASCADE keyword if there are dependent privileges that have to be revoked in consequence.) Or you can log in as "otherUser" and revoke the privilege grants made by that role. This is per design and AFAIK it's per the SQL standard's requirements.
There's a lot of fine print in the Notes sections of the GRANT and REVOKE reference pages, which you might find helpful. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs