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

User without rights can create an database

    XMLWordPrintable

Details

    Description

      An user without any rights can creates an database, when it is called "test".

      MariaDB [(none)]> create database test1;
      ERROR 1044 (42000): Access denied for user 'foo@'localhost' to database 'test1'
      MariaDB [(none)]> create database test;
      Query OK, 1 row affected (0.000 sec)
      

      As root:

      MariaDB [(none)]> show grants for 'foo'@'localhost';
      +-------------------------------------------------------------------------------+
      | Grants for foo@localhost                                           |
      +-------------------------------------------------------------------------------+
      | GRANT USAGE ON *.* TO 'foo'@'localhost' IDENTIFIED VIA unix_socket |
      +-------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            mariaTux Frank
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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