"McGehee, Robert" <Robert.McGehee@xxxxxxxxxxxxxxxx> 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 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
