CODEWITHSUNDEEP
postgresqlprivilegesroleusergroups
perryzheng
perryzheng

Reputation: 199

Postgres: how to grant an user to add more users to a group

So I know in postgres a group is nothing but a role. But I'll still use groups here.

Say I created a group called my_group as superuser.

I am user user_1.

I want to give user_1 permission to add more users into my_group.

What is the command I need to do as superuser to do that?

Upvotes: 5

Views: 1845

Answers (1)

Michel Milezzi
Michel Milezzi

Reputation: 11155

Use GRANT WITH ADMIN OPTION to do that:

GRANT my_group TO user_1 WITH ADMIN OPTION;

More info here.

Upvotes: 3

Related Questions