pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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