postgresqlpostgresql-9.1role

Grant "create schema" ON database to a user?

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

How can I do that?

Solution

  • It's more simple than I thought.

    GRANT CREATE ON DATABASE db TO user;