Re: [GENERAL] Role inheritance and Conflicting Parameter Values

2014-06-23 Thread Rene Romero Benavides
As far as I'm concerned, you cannot inherit role settings, only privileges. http://www.postgresql.org/docs/9.3/static/role-membership.html 2014-06-23 20:12 GMT-05:00 Rene Romero Benavides : > To impersonate another role, as a superuser or group member use: > SET SESSION AUTHORIZATION user1; > >

Re: [GENERAL] Role inheritance and Conflicting Parameter Values

2014-06-23 Thread Rene Romero Benavides
To impersonate another role, as a superuser or group member use: SET SESSION AUTHORIZATION user1; http://www.postgresql.org/docs/9.3/static/sql-set-session-authorization.html Regards. 2014-06-23 8:25 GMT-05:00 McGehee, Robert : > Hi, > > I'm trying to set the default statement_timeout paramete

Re: [GENERAL] Role inheritance and Conflicting Parameter Values

2014-06-23 Thread Tom Lane
"McGehee, Robert" writes: > I'm trying to set the default statement_timeout parameter for two different > groups of users. However, as many of the users inherit from overlapping > roles, I wanted to get clarification on how inheritance of parameter values > worked when a role inherits from othe

[GENERAL] Role inheritance and Conflicting Parameter Values

2014-06-23 Thread McGehee, Robert
Hi, I'm trying to set the default statement_timeout parameter for two different groups of users. However, as many of the users inherit from overlapping roles, I wanted to get clarification on how inheritance of parameter values worked when a role inherits from other roles that all have different