November 7th, 2009 by depesz | Tags: grant, grantall, pg85, pg90, postgresql, privileges, revoke | 10 comments »
One of the most common (or perhaps even the most common) question people have regarding PostgreSQL, is how to change privileges for all tables. Usually they want something like MySQL's: GRANT ... ON database.* TO ... Which is interesting as it is actually ...
January 31st, 2009 by depesz | Tags: columns, grant, pg84, postgresql, privileges, revoke | 4 comments »
On 22nd of January, Tom Lane committed patch by Stephen Frost, which adds column level privileges: Log Message: ----------- Support column-level privileges, as required by SQL standard. Stephen Frost, with help from KaiGai Kohei and others
