Setting GPDB Parameters at the Role Level

posted Sep 13, 2012, 1:16 PM by Sachchida Ojha
When a session parameter is set at the role level, every session initiated by that role will pick up that parameter setting. Settings at the role level override those at the database level. Use the ALTER ROLE command to set a parameter at the role level. For example:

=# ALTER ROLE bob SET search_path TO bobschema;