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

The following bug has been logged online:

Bug reference:      1221
Logged by:          radim kolar

Email address:      hsn@netmag.cz

PostgreSQL version: 7.4.1

Operating system:   freebsd

Description:        revoke on schema do not return error on failure

Details:

Problem 1
pgsql 7.4.1

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

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.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