"McGehee, Robert" <robert.mcge...@geodecapital.com> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
