Re: who can create schema?

Richard Hayward <richard@tortoise.demon.co.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