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 2 distinct features in one:
- grant privileges on all existing tables
- automatically grant privileges on all tables that will be created in this database in the future
Now, thanks to 2 new patches – we have this possibility in PostgreSQL.
Continue reading Waiting for 8.5 – “GRANT ALL"
One of my clients hit a strange limitation – apparently you cannot inherit CREATE ROLE privilege.
First, let's test if it's really true:
Continue reading CREATE ROLE privilege cannot be inherited?!
On 22nd of January, Tom Lane committed patch by Stephen Frost, which adds column level privileges:
Support column-level privileges, as required by SQL standard.
Stephen Frost, with help from KaiGai Kohei and others
Continue reading Waiting for 8.4 – column level privileges.