Horton

Re: [HACKERS] Re: [PORTS] Port Bug Report: Grant select to other user removes owner select permission

Andrew Martin <martin@biochemistry.ucl.ac.uk>

View thread
From: Andrew Martin <martin@biochemistry.ucl.ac.uk>
To: hackers@postgresql.org
Date: 1998-03-16T12:48:16Z
Lists: pgsql-hackers 
> Does anyone want to comment on this?
> 
> > Summary: Grant select to other user removes owner select permission
> > 
> >   Operating System   : Linux 2.0.33 Elf Slackware
> > 
> >   PostgreSQL version : 6.3
> > 
> > If a user creates a table, and then grants select privs to another user, the owner of the table can no longer select withouth first granting himself select privs.
> > No other permissions testing was done, fyi.
> > 

Same here under Irix....

Andrew

----------------------------------------------------------------------------
Dr. Andrew C.R. Martin                             University College London
EMAIL: (Work) martin@biochem.ucl.ac.uk    (Home) andrew@stagleys.demon.co.uk
URL:   http://www.biochem.ucl.ac.uk/~martin
Tel:   (Work) +44(0)171 419 3890                    (Home) +44(0)1372 275775