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

SHOW GRANTS for PUBLIC should work for all users

    XMLWordPrintable

Details

    Description

      MariaDB [(none)]> show grants;
      		 
      +------------------------------------------------+
      		 
      | Grants for developer@%                         |
      		 
      +------------------------------------------------+
      		 
      | GRANT USAGE ON *.* TO `developer`@`%`          |
      		 
      | GRANT ALL PRIVILEGES ON `dev_db`.* TO `PUBLIC` |
      		 
      +------------------------------------------------+
      		 
      2 rows in set (0.000 sec)
      		 
       
      		 
      MariaDB [(none)]> show grants for public;
      		 
      ERROR 1044 (42000): Access denied for user 'developer'@'%' to database 'mysql'

      Any user can see public's grants by running their own SHOW GRANTS command. This means that SHOW GRANTS FOR PUBLIC should also be allowed.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-5215 Granted to PUBLIC

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              cvicentiu Vicențiu Ciorbaru
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.