Database Privileges
Only a database superuser can create a database. In a new database, the PUBLIC Role is granted USAGE on the automatically-created PUBLIC schema. It is up to the superuser to grant further privileges to users and roles.
The only privilege a superuser can grant on the database itself is CREATE, which allows the user to create a new schema in the database. For details on granting and revoking privileges on a database, see the GRANT (Database) and REVOKE (Database) topics in the SQL Reference Manual.
Privilege | Grantor | Description |
---|---|---|
CREATE |
Superuser |
Allows a user to create a schema. |