Search code examples
postgresqldatabase-permissions

Postrgres : overload the inheritance of a group rigths


I would like to know if it's possible under Postgres for a role to inherit the rights of a group while removing the DELETE right from it.


Solution

  • No, permissions in SQL are always additive, and a role's permissions are the sum of its own privileges and the ones inherited from roles it is a member of.