On 11/05/2022 11:55, Roman Simakov wrote: > 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. >
In the profiler, I will create a role, the tables and views in another connection. I'll grant privileges to the role and default grant the role to public (currently not working due to #7178, so I'm testing with another user instead of public). But the user connection is already made and is going to use the profiler. Now I need to see what is its current_role, then "set role plg$profiler" (or any other role different than current), then "set role old_current_role" to refresh the current roles. > If a role is revoked from a user, it will affect the > next attachment only, won't it? I think this can be considered as a not well defined behavior and changeable, but anyway, if there is simple command to refresh the active roles instead of automatically, it's not going to be a problem. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
