Postgres Pro
Downloads
Home   >   mailing lists

BUG #1221: revoke on schema do not return error on failure - Mailing list pgsql-bugs

From PostgreSQL Bugs List
Subject BUG #1221: revoke on schema do not return error on failure
Date
Msg-id 20040817184040.B242C5A1141@www.postgresql.com
Whole thread Raw
Responses Re: BUG #1221: revoke on schema do not return error on failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1208: Invalid page header
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1222: database owner should have implicit control over public db schema