"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
