Hi Vladimir,
There’s currently no such function available. Even if we had a user:kill function, we could not ensure that a user logs in a millisecond later when user:drop is going to be executed. We could enrich user:drop et al. with an “enforce” option to kill users, but the challenge is that a user may currently execute a long-running update query that needs to be finalized before the user can be dropped, thus delaying the execution of the user:drop operation and possible other subsequent requests.
Have you already observed the presented pattern?
Best, Christian
On Fri, Apr 5, 2024 at 10:36 AM Ветошкин Владимир en-trance@yandex.ru wrote:
Hi,
How can I kill session and then user:grant or user:drop permissions in a single command? When I make it in two different commands - user logins between them and the second command gets error, that the user is currently logged in.
-- С уважением, Ветошкин Владимир Владимирович