5

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?

ekad
  • 14,436
  • 26
  • 44
  • 46
perryzheng
  • 199
  • 1
  • 8

1 Answers1

3

Use GRANT WITH ADMIN OPTION to do that:

GRANT my_group TO user_1 WITH ADMIN OPTION; 

More info here.

Michel Milezzi
  • 10,087
  • 3
  • 21
  • 36