who can create schema?

From: Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: who can create schema?
Date: 2005-05-28 10:13:48
Message-ID: icgg91lioonncfun1arhc8rru17vuv95bv@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL 7.3.2

I'm trying to investigate why users can create new schema within a
database, without being explicitly being granted create permission on
that database.

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

And then, within a given schema, how could I list who can create new
objects?

Could anyone tell me?

regards
Richard

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message vamsi krishna 2005-05-28 13:07:34 Create relation
Previous Message Vamsi Krishna G 2005-05-28 08:53:05 Create relation