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  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: "Josef Springer"
Дата:
Сообщение: BUG #1792: Encoding vovels
Следующее
От: André Laugks
Дата:
Сообщение: Re: [postgres] Teilstring auslesen