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

REVOKE ... FROM username equals REVOKE ... FROM PUBLIC

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: REVOKE ... FROM username equals REVOKE ... FROM PUBLIC
Date: 2001-05-31 13:48:50
Message-ID: 200105311348.f4VDmoP83621@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Jean-Francois Leveque (leveque(at)webmails(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
REVOKE ... FROM username equals REVOKE ... FROM PUBLIC

Long Description
System: SuSE 7.0
PostgreSQL RPM: postgres-7.0.2-29
select version(); :
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2

When I revoke select from a user, it revokes select from other
users, database object owner included.


Sample Code
test:~ > createdb bugcheck
CREATE DATABASE
test:~ > psql bugcheck
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit
 
bugcheck=> CREATE TABLE bugtable (
bugcheck(> bugcolumn int);
CREATE
bugcheck=> select * from bugtable;
 bugcolumn
-----------
(0 rows)
 
bugcheck=> REVOKE SELECT ON bugtable FROM nobody;
CHANGE
bugcheck=> select * from bugtable;
ERROR:  bugtable: Permission denied.


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-05-31 14:25:00
Subject: Re: REVOKE ... FROM username equals REVOKE ... FROM PUBLIC
Previous:From: shashi ahujaDate: 2001-05-31 12:44:45
Subject: Problem with sql

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