Skip site navigation (1) Skip section navigation (2)

Re: REVOKE not working...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: REVOKE not working...
Date: 2004-10-21 03:34:04
Message-ID: 10987.1098329644@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Joe Maldonado <jmaldonado(at)webehosting(dot)biz> writes:
>     But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser;
> The user can still create tables...

CREATE privilege on a database concerns the right to create schemas
within the database.  Whether you can create tables within a schema
is a different privilege on a different object.  In particular, the
default setup is that everyone can create tables within the "public"
schema in each database.  Revoke CREATE on that (from PUBLIC, not just
myuser) and you'll start to get somewhere.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Nikhil ParvaDate: 2004-10-21 05:56:22
Subject: unsubscribe
Previous:From: WeipingDate: 2004-10-21 03:13:46
Subject: Re: large dumps won't restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group