| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikhil Parva | 2004-10-21 05:56:22 | unsubscribe |
| Previous Message | Weiping | 2004-10-21 03:13:46 | Re: large dumps won't restore |