From: | "Sean Burlington" <sean(at)uncertainty(dot)org(dot)uk> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1794: inheritance removes permissions from the parent table |
Date: | 2005-07-28 11:48:35 |
Message-ID: | 20050728114835.E5531F0B01@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
The following bug has been logged online:
Bug reference: 1794
Logged by: Sean Burlington
Email address: sean(at)uncertainty(dot)org(dot)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...
From | Date | Subject | |
---|---|---|---|
Next Message | kam k | 2005-07-28 12:21:47 | BUG #1795: mirroring |
Previous Message | H. Schumacher | 2005-07-28 08:41:57 | BUG #1793: ODBC crashs without C:\ |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-07-28 13:51:13 | Re: BUG #1794: inheritance removes permissions from the parent table |
Previous Message | Tom Lane | 2005-07-28 06:34:59 | Re: PLPGSQL OID Bug |