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

Started by Andrew Martinabout 28 years ago2 messageshackers
Jump to latest
#1Andrew Martin
martin@biochemistry.ucl.ac.uk

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Andrew Martin (#1)
Re: [HACKERS] Re: [PORTS] Port Bug Report: Grant select to other user

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....

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)