If not specified, NOCREATEROLE is the default. See role creation for more details about what capabilities are conferred by this privilege. These clauses determine whether a role will be permitted to create, alter, drop, comment on, and change the security label for other roles. Only superuser roles or roles with CREATEDB can specify CREATEDB. If not specified, NOCREATEDB is the default. Specifying NOCREATEDB will deny a role the ability to create databases. If CREATEDB is specified, the role being defined will be allowed to create new databases. These clauses define a role's ability to create databases. If not specified, NOSUPERUSER is the default. You must yourself be a superuser to create a new superuser. Superuser status is dangerous and should be used only when really needed. These clauses determine whether the new role is a “ superuser”, who can override all access restrictions within the database.