Re: [HACKERS] Partitioned tables vs GRANT

2017-04-07 Thread Keith Fiske
On Fri, Apr 7, 2017 at 8:41 PM, Tom Lane wrote: > Keith Fiske writes: > > On Fri, Apr 7, 2017 at 2:46 PM, Tom Lane wrote: > >> Joe Conway writes: > >>> Apparently INSERT and SELECT on the parent partitioned table skip > normal > >>> acl checks on the partitions. Is that intended behavior? > >

Re: [HACKERS] Partitioned tables vs GRANT

2017-04-07 Thread Tom Lane
Keith Fiske writes: > On Fri, Apr 7, 2017 at 2:46 PM, Tom Lane wrote: >> Joe Conway writes: >>> Apparently INSERT and SELECT on the parent partitioned table skip normal >>> acl checks on the partitions. Is that intended behavior? >> Yes, this matches normal inheritance behavior. > Should that

Re: [HACKERS] Partitioned tables vs GRANT

2017-04-07 Thread Keith Fiske
On Fri, Apr 7, 2017 at 2:46 PM, Tom Lane wrote: > Joe Conway writes: > > Apparently INSERT and SELECT on the parent partitioned table skip normal > > acl checks on the partitions. Is that intended behavior? > > Yes, this matches normal inheritance behavior. > > regards, t

Re: [HACKERS] Partitioned tables vs GRANT

2017-04-07 Thread Tom Lane
Joe Conway writes: > Apparently INSERT and SELECT on the parent partitioned table skip normal > acl checks on the partitions. Is that intended behavior? Yes, this matches normal inheritance behavior. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hacke

Re: [HACKERS] Partitioned tables vs GRANT

2017-04-07 Thread Keith Fiske
On Fri, Apr 7, 2017 at 2:05 PM, Joe Conway wrote: > Apparently INSERT and SELECT on the parent partitioned table skip normal > acl checks on the partitions. Is that intended behavior? > > 8<--- > test=# create user part_test; > CREATE ROLE > test=# > test=# create table t1

[HACKERS] Partitioned tables vs GRANT

2017-04-07 Thread Joe Conway
Apparently INSERT and SELECT on the parent partitioned table skip normal acl checks on the partitions. Is that intended behavior? 8<--- test=# create user part_test; CREATE ROLE test=# test=# create table t1 (id int) partition by range ((id % 4)); CREATE TABLE test=# create