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

On Sat, 28 May 2005 11:13:48 +0100, Richard Hayward
<richard@tortoise.demon.co.uk> wrote:

>PostgreSQL 7.3.2

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

ok, I've found the answer to this bit: Upgrading to 8.0.3 gives the
psql \dn+ command.

However \l+ does not return the equivalent permission information on
databases.

Richard

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend