Grant "create schema" ON database to a user?

Question

I'm using PostgreSQL 9.1 and have to to grant "create schema" ON database to a user.

How can I do that?

-> [The fine manual](http://www.postgresql.org/docs/current/interactive/sql-grant.html). — Erwin Brandstetter, Jun 01 '12 at 16:18

score 107 · Accepted Answer · edited May 17 '18 at 07:05

107

It's more simple than I thought.

GRANT CREATE ON DATABASE db TO user;

edited May 17 '18 at 07:05

Steve Bennett

answered Jun 01 '12 at 14:54

matheusvmbruno

is there documentation for this anywhere? The postgres docs are pretty scant on info about what the various GRANTs do.... – Him May 30 '23 at 23:05

1 Answers1