The following bug has been logged online:

Bug reference: 1221
Logged by: radim kolar

Email address: hsn (AT) netmag (DOT) 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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html