Default roles... by default
305665Oct 22 2007 — edited Oct 22 2007Is there a way to have a role be default by default. In other words rather than
1. grant a role to a user
and then
2. make that role default for each user granted the role (i.e. ALTER USER user_name DEFAULT ROLE role_name;)
is there a way to have #2 above happen automatically when granting a role to a user? So that by default, roles granted are enabled as a default role for the user?
Thanks.