Not everyone knows, but at since PostgreSQL 9.6, we have some built-in roles.
Of course, there is always superuser (usually called postgres), but I'm not talking about it. I'm talking about magical roles that have names starting with pg_.
Not everyone knows, but at since PostgreSQL 9.6, we have some built-in roles.
Of course, there is always superuser (usually called postgres), but I'm not talking about it. I'm talking about magical roles that have names starting with pg_.
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?!