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

implement SHOW CREATE ROLE

    XMLWordPrintable

    Details

      Description

      SHOW CREATE ROLE doesn't work.

      See here:

      MariaDB [(none)]> CREATE ROLE 'admin_role';
      Query OK, 0 rows affected (0.002 sec)
       
      MariaDB [(none)]> CREATE ROLE 'user_role'  WITH ADMIN 'admin_role';
      Query OK, 0 rows affected (0.004 sec)
       
      MariaDB [(none)]> SHOW CREATE ROLE 'user_role';
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ROLE 'user_role'' at line 1
      

      Since you can create a role with its own WITH ADMIN clause, this statement should be implemented, so that all role attributes can be easily printed.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ralf.gebhardt@mariadb.com Ralf Gebhardt
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated: