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.
Postrgres : overload the inheritance of a group rigths
58 views Asked by Dieg13 At
1
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.
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.