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

SHOW GRANTS output doesn't show the GRANT OPTION if ROLE is created with it.

    XMLWordPrintable

Details

    Description

      SHOW GRANTS output doesn't show the GRANT OPTION if ROLE is created with it.

      MariaDB [(none)]> CREATE ROLE DB_Admin;
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO 'DB_Admin' WITH GRANT OPTION;
      Query OK, 0 rows affected (0.001 sec)
       
      MariaDB [(none)]> SHOW GRANTS for 'DB_Admin';
      +---------------------------------------------------------------+
      | Grants for MariaDB_admin                                      |
      +---------------------------------------------------------------+
      | GRANT SELECT, UPDATE, DELETE, ALTER ON *.* TO `MariaDB_admin` |
      +---------------------------------------------------------------+
      1 row in set (0.000 sec)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              niljoshi Nilnandan Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.