Skip site navigation (1) Skip section navigation (2)

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

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1221: revoke on schema do not return error on failure
Date: 2004-08-17 18:40:40
Message-ID: 20040817184040.B242C5A1141@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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



Responses

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-08-17 18:43:13
Subject: BUG #1222: database owner should have implicit control over public db schema
Previous:From: Tom LaneDate: 2004-08-17 17:10:11
Subject: Re: BUG #1208: Invalid page header

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group