The following bug has been logged online: Bug reference: 1794 Logged by: Sean Burlington Email address: [EMAIL PROTECTED] 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... ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
