Grant to Create User in PostgreSQL

Question

I need create a user only to create others users, but, i don't know how create a grant to this? Exist a method for this, or i need use GRANT ALL PRIVILEGES?

jcern · Accepted Answer · 2012-10-02 20:06:22Z

3

You can find the available permissions here: http://www.postgresql.org/docs/9.1/static/sql-createuser.html

I believe the one you are looking for is CREATEUSER

The full command you'd want to execute is:

CREATE USER username WITH CREATEUSER;

edited Oct 2, 2012 at 20:06

answered Oct 2, 2012 at 19:56

jcern

7,8584 gold badges42 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jason Swett Over a year ago

I'd say this is correct. I'd also suggest that you might like to do something like this on the command line: createuser -P -s -e <username>. I personally find that way of doing it handier.

greg Over a year ago

\h CREATE USER may also help ;)

Collectives™ on Stack Overflow

Grant to Create User in PostgreSQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related