Sample Header Ad - 728x90

How can I setup users/groups in PostgreSQL so that each user has privileges on objects created by other users in the same group?

0 votes
1 answer
249 views
I have created a group (role) called "employees" and I've created some users that are its member and that inherit its rights. I have a database owned by the group "employees". The goal: To setup things in a way that allows all of the users to work with all of the objects in the database. The problem: I can't expect the users to set the owner to "employees" when they create a new object, because they use various limited interfaces to work with the database. When they create a schema or a table, it gets created with the user as its owner, which means that the other users don't have rights on that schema/table. I'm using PostgreSQL 11.2.
Asked by user183865
Jun 23, 2019, 09:45 PM
Last activity: May 21, 2025, 07:03 PM