On 26th of March 2021, Noah Misch committed patch:
Add "pg_database_owner" default role.
Membership consists, implicitly, of the current database owner. Expect
use in template databases. Once pg_database_owner has rights within a
template, each owner of a database instantiated from that template will
exercise those rights.
Reviewed by John Naylor.
Continue reading Waiting for PostgreSQL 14 – Add “pg_database_owner" default role.
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"
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.