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

            Activity

              People

              Assignee:
              cvicentiu Vicențiu Ciorbaru
              Reporter:
              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.