Re: who can create schema?

Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk> writes:
> I'm trying to investigate why users can create new schema within a
> database, without being explicitly being granted create permission on
> that database.

By default, they can't. Perhaps you granted create permission on the
database to PUBLIC? Also, are you sure the users in question are
not superusers?

> I cant find a command that lists what privileges users have been
> granted within a database. Can they create new schema or not?

There doesn't seem to be a psql backslash command that shows permissions
on databases; you'd need to look directly at pg_database, eg

select datname, datacl from pg_database;

regards, tom lane