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-tra...@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. > > -- > С уважением, > Ветошкин Владимир Владимирович > >
