1

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?

Tommy
  • 265
  • 1
  • 6
  • 15

1 Answers1

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;
jcern
  • 7,798
  • 4
  • 39
  • 47
  • 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 `. I personally find that way of doing it handier. – Jason Swett Oct 02 '12 at 20:34
  • \h CREATE USER may also help ;) – greg Oct 03 '12 at 12:27