Can you make up or describe a potential case of the situation?
Undoubtedly the feature would be useful but we've lived without it for
all the time. If a role is revoked from a user, it will affect the
next attachment only, won't it?

ср, 11 мая 2022 г. в 16:36, Adriano dos Santos Fernandes <adrian...@gmail.com>:
>
> Hi!
>
> When roles are default granted to an user, they are not immediately
> reflected in the attachments.
>
> Attachments need to issue a SET ROLE which should be different than
> currently used, then another SET ROLE to the correct one to refresh the
> roles. Or re-attach.
>
> I think we should improve that automatically refreshing roles via AST or
> creating some command like ALTER SESSION REFRESH ROLES.
>
>
> Adriano
>
>
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Роман Симаков


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to