Re: [HACKERS] Re: [PORTS] Port Bug Report: Grant select to other user removes owner select permission - Mailing list pgsql-hackers

From Andrew Martin
Subject Re: [HACKERS] Re: [PORTS] Port Bug Report: Grant select to other user removes owner select permission
Date
Msg-id 199803161248.MAA21916@bsmir06.biochem.ucl.ac.uk
Whole thread Raw
Responses Re: [HACKERS] Re: [PORTS] Port Bug Report: Grant select to other user
List 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
selectwithouth 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

pgsql-hackers by date:

Previous
From: "Pedro J. Lobo"
Date:
Subject: Problems testing previous snapshots on alpha
Next
From: Bruce Momjian
Date:
Subject: Re: [QUESTIONS] MySQL benchmark page