Re: Permission denied on schema for all users on insert to table with fk

2018-07-26 Thread Leland Weathers
On Thu, Jul 26, 2018 at 9:19 AM, Adrian Klaver wrote: > On 07/26/2018 06:57 AM, Leland Weathers wrote: > > >> >> Before you mentioned a trigger. I am not seeing that in the schema >> you sent. Is there one and if so what is it's definition and that of >> its associated function? >> >>

Re: Permission denied on schema for all users on insert to table with fk

2018-07-26 Thread Leland Weathers
On Thu, Jul 26, 2018 at 8:31 AM, Adrian Klaver wrote: > On 07/26/2018 03:52 AM, Leland Weathers wrote: > >> >> >> > > > >> And a more complete example of what we are seeing with multiple >> accounts. This particular set is from an account that has their role >> set to that of the data

Re: Permission denied on schema for all users on insert to table with fk

2018-07-26 Thread Leland Weathers
On Wed, Jul 25, 2018 at 11:32 AM, Adrian Klaver wrote: > On 07/25/2018 06:40 AM, Leland Weathers wrote: > >> I just ran into an issue on 9.5.13 after creating a new schema with a set >> of tables in them, that no accounts (including schema / table owners) can >> insert into a table with a fk rela

Re: Permission denied on schema for all users on insert to table with fk

2018-07-26 Thread Adrian Klaver
On 07/26/2018 06:57 AM, Leland Weathers wrote: Before you mentioned a trigger. I am not seeing that in the schema you sent. Is there one and if so what is it's definition and that of its associated function? I was referring to the "built-in" PostgreSQL system trigger for validat

Re: Permission denied on schema for all users on insert to table with fk

2018-07-26 Thread Adrian Klaver
On 07/26/2018 03:52 AM, Leland Weathers wrote: And a more complete example of what we are seeing with multiple accounts. This particular set is from an account that has their role set to that of the database & schema owner which is different than the table owner role.

Re: Permission denied on schema for all users on insert to table with fk

2018-07-25 Thread Adrian Klaver
On 07/25/2018 06:40 AM, Leland Weathers wrote: I just ran into an issue on 9.5.13 after creating a new schema with a set of tables in them, that no accounts (including schema / table owners) can insert into a table with a fk relation. A snippet of the error output in log files is as follows and

Permission denied on schema for all users on insert to table with fk

2018-07-25 Thread Leland Weathers
I just ran into an issue on 9.5.13 after creating a new schema with a set of tables in them, that no accounts (including schema / table owners) can insert into a table with a fk relation. A snippet of the error output in log files is as follows and looks like it is permissions related to the parent