Thread: Re: [HACKERS] Re: [PORTS] Port Bug Report: Grant select to other user removes owner select permission
Re: [HACKERS] Re: [PORTS] Port Bug Report: Grant select to other user removes owner select permission
From
Andrew Martin
Date:
> 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
> > > 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.... Added to TODO. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)