"McGehee, Robert" <Robert.McGehee@geodecapital.com> writes:
> I'm trying to set the default statement_timeout parameter for two different groups of users. However, as many of the
usersinherit from overlapping roles, I wanted to get clarification on how inheritance of parameter values worked when a
roleinherits from other roles that all have different settings for a parameter value.
I'm pretty sure there is no inheritance for ALTER ROLE SET parameters.
Role inheritance only applies to grantable permissions.
> Also, as a superuser, can I examine the parameter values for another
> user to make sure I set this correctly.
You can certainly look at the pg_db_role_setting catalog to find this out.
I don't remember offhand if there are any system views that present the
information in a more friendly fashion.
regards, tom lane