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

Re: BUG #1221: revoke on schema do not return error on failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "radim kolar" <hsn(at)netmag(dot)cz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1221: revoke on schema do not return error on failure
Date: 2004-08-17 18:59:39
Message-ID: 8650.1092769179@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> revoke create on schema do not issues an error when user has no access
> privileges to do that.

> dbmail=>  REVOKE CREATE ON SCHEMA public FROM PUBLIC;
> REVOKE
> Grant works as expected
> dbmail=> GRANT USAGE on SCHEMA public to public;
> ERROR:  permission denied for schema public

In 8.0 both of these cases will return WARNINGs (not errors).  This is
per our current reading of the SQL specification.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-08-17 19:02:12
Subject: Re: BUG #1222: database owner should have implicit control over public db schema
Previous:From: PostgreSQL Bugs ListDate: 2004-08-17 18:43:13
Subject: BUG #1222: database owner should have implicit control over public db schema

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