"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;
> 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 Lane||Date: 2004-08-17 19:02:12|
|Subject: Re: BUG #1222: database owner should have implicit control over public db schema |
|Previous:||From: PostgreSQL Bugs List||Date: 2004-08-17 18:43:13|
|Subject: BUG #1222: database owner should have implicit control over public db schema|