BUG #1794: inheritance removes permissions from the parent table
| От | Sean Burlington |
|---|---|
| Тема | BUG #1794: inheritance removes permissions from the parent table |
| Дата | |
| Msg-id | 20050728114835.E5531F0B01@svr2.postgresql.org обсуждение |
| Ответы |
Re: BUG #1794: inheritance removes permissions from the parent table
|
| Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1794 Logged by: Sean Burlington Email address: sean@uncertainty.org.uk PostgreSQL version: 7.4 Operating system: Debian GNU/Linux Description: inheritance removes permissions from the parent table Details: Hi, I'm not sure if this is strictly a bug or just a side effect of inheritance that could do with being added to the documentation. If you create a new table that inherits from another table - a user cannot select from the parent if they cannot select from the child. To recreate: as dba create table a (id int); grant select on a to auser; insert into a (id) values (1); as auser select * from a; id ---- 1 as dba create table b (data int) inherits (a); as auser select * from a; ERROR: permission denied for relation b I didn't expect to need permission for table b in order to select from a...
В списке pgsql-bugs по дате отправления: