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

              Assignee:
              Unassigned Unassigned
              Reporter:
              niljoshi Nilnandan Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration