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

BUG #1161: User permissions are kept, even if user is dropped

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1161: User permissions are kept, even if user is dropped
Date: 2004-06-07 19:38:57
Message-ID: 20040607193857.0BFD8CF4B00@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1161
Logged by:          Martin

Email address:      martin(at)4finger(dot)net

PostgreSQL version: 7.4

Operating system:   Linux

Description:        User permissions are kept, even if user is dropped

Details: 

Hi,

dropping and creating a user will keep the *old* permission on objects:

The following statements will grant access to the user
foe:

  create user friend; 
  create table secret (passwd char(30));
  grant all on secret to friend; 
  \dp secret; 
  drop user friend; 
  -- The permissions are still existing 
  -- (on a numeric user-id)
  \dp secret; 
  create user foe;
  -- The user foe "inherits" the old permissions
  \dp secret;

This is not what I would have expected.  If this behaviour is valid, there 
should be a warning in the documentation, that creating a user may inherit 
some "dangling" permissions. 

Best regards,
Martin



Responses

pgsql-bugs by date

Next:From: Scott MarloweDate: 2004-06-07 19:58:19
Subject: Re: [GENERAL] bug in 7.4.2, concern unicode and russian content of
Previous:From: Alexander S.Date: 2004-06-07 18:11:33
Subject: bug in 7.4.2, concern unicode and russian content of db

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