pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
who can create schema?
3+ messages / 2 participants
[nested] [flat]

* who can create schema?
@ 2005-05-28 10:13  Richard Hayward <richard@tortoise.demon.co.uk>
  0 siblings, 2 replies; 3+ messages in thread

From: Richard Hayward @ 2005-05-28 10:13 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: who can create schema?
@ 2005-05-31 09:23  Richard Hayward <richard@tortoise.demon.co.uk>
  parent: Richard Hayward <richard@tortoise.demon.co.uk>
  1 sibling, 0 replies; 3+ messages in thread

From: Richard Hayward @ 2005-05-31 09:23 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: who can create schema?
@ 2005-05-31 18:41  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Richard Hayward <richard@tortoise.demon.co.uk>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2005-05-31 18:41 UTC (permalink / raw)
  To: Richard Hayward <richard@tortoise.demon.co.uk>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-05-31 18:41 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-28 10:13 who can create schema? Richard Hayward <richard@tortoise.demon.co.uk>
2005-05-31 09:23 ` Richard Hayward <richard@tortoise.demon.co.uk>
2005-05-31 18:41 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox