Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-35617

DROP USER should leave no active session for that user

Details

    • Q2/2025 Development

    Description

      DROP USER deletes specified user, while there is connected session of user deleted. After deletion user is still able to select or modify data in that session. Is that a bug or designed behavior? How can I prevent deleted user from further actions in that session?

      Version:11.4.2-MariaDB

      Voting initiated on the page https://mariadb.org/tell-us-how-to-drop-user/ gives the result shown in the attachments section.
      In according with voting results, the most popular choice on possible behavior of the statement "DROP USER" seems to be "Terminate all existing connections of the user". But note that the set of choices was not mutually exclusive. There were only three mutually exclusive choices "Keep the old behaviour", "DROP USER should terminate all existing connections", "DROP USER should wait". And the third option "should wait" got the most votes. Also, most of people who thought that DROP USER should wait, also thought there should be a FORCE option.

      Summing up the survey, server should do the following steps on executing the DROP USER statement:

      • Server stops accepting any connections on behalf the user being dropped
      • In case the option `FORCE` is NOT specified for DROP USER statement, MariaDB server is waiting until all connections established on behalf the user specified by DROP USER statement be disconnected
      • The specified user is dropped
      • In case the option FORCE is specified for DROP USER statement, all active connections be forcibly terminated

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Dmitry Shulga made transition -
            Open In Progress
            133d 19h 3m 1

            People

              shulga Dmitry Shulga
              balta Tadas BalaiĊĦis
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.