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

Bug #746: Drop user damages security on tables

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #746: Drop user damages security on tables
Date: 2002-08-26 14:23:29
Message-ID: 20020826142329.1F7A5475966@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Mickey Parker (parkerm(at)hst(dot)stoneridge(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Drop user damages security on tables

Long Description
A user was setup and had GRANT permissions on individual tables in a database.  After the user was dropped, using the /z from psql command line showed the user ID still existing in the individual table permissions.  After the drop, several other users then were unable to execute SELECT or INSERT on this table.  These users would get a -601 error when trying to do a SELECT or INSERT.  Also, trying to REVOKE permissions on the user ID that belonged to the dropped user resulted in a parse error.

Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-08-26 14:42:36
Subject: Re: Bug #746: Drop user damages security on tables
Previous:From: Tom LaneDate: 2002-08-26 04:34:00
Subject: Re: c.h needed in Pg.c

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