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

SHOW GRANTS does not prints a user's default role

Details

    Description

      Let's say that we create a role and a user account:

      MariaDB [(none)]> CREATE ROLE 'test_role';
      		 
      Query OK, 0 rows affected (0.004 sec)
      		 
       
      		 
      MariaDB [(none)]> CREATE USER 'test_user'@'%';
      		 
      Query OK, 0 rows affected (0.004 sec)

      And then let's say that we set this role to be the default role for the user account:

      MariaDB [(none)]> GRANT 'test_role' TO 'test_user'@'%';
      		 
      Query OK, 0 rows affected (0.004 sec)
      		 
       
      		 
      MariaDB [(none)]> SET DEFAULT ROLE 'test_role' FOR 'test_user'@'%';
      		 
      Query OK, 0 rows affected (0.004 sec)

      Neither SHOW CREATE USER now SHOW GRANTS prints this default role for the user account:

      MariaDB [(none)]> SHOW CREATE USER 'test_user'@'%';
      		 
      +-----------------------------+
      		 
      | CREATE USER for test_user@% |
      		 
      +-----------------------------+
      		 
      | CREATE USER 'test_user'@'%' |
      		 
      +-----------------------------+
      		 
      1 row in set (0.000 sec)
      		 
       
      		 
      MariaDB [(none)]> SHOW GRANTS FOR 'test_user'@'%';
      		 
      +---------------------------------------+
      		 
      | Grants for test_user@%                |
      		 
      +---------------------------------------+
      		 
      | GRANT test_role TO 'test_user'@'%'    |
      		 
      | GRANT USAGE ON *.* TO 'test_user'@'%' |
      		 
      +---------------------------------------+
      		 
      2 rows in set (0.000 sec)

      In my opinion, it should at least be printed by SHOW GRANTS, since it is somewhat related to one of the grants that is printed.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-23630 mysqldump to logically dump system tables

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26080 SHOW GRANTS does not quote role names properly for DEFAULT ROLE

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-22311 implement SHOW CREATE ROLE

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22312 Bad error message for SET DEFAULT ROLE when user account is not granted the role

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Field Original Value New Value
            GeoffMontee Geoff Montee (Inactive) made changes -
            anel Anel Husakovic made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Anel Husakovic [ anel ]
            anel Anel Husakovic made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            Summary Neither SHOW CREATE USER nor SHOW GRANTS prints a user's default role SHOW GRANTS does not prints a user's default role
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Anel Husakovic [ anel ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Anel Husakovic [ anel ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Anel Husakovic [ anel ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Anel Husakovic [ anel ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            anel Anel Husakovic made changes -
            Fix Version/s 10.2.35 [ 25022 ]
            Fix Version/s 10.3.26 [ 25021 ]
            Fix Version/s 10.4.16 [ 25020 ]
            Fix Version/s 10.5.7 [ 25019 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            anel Anel Husakovic made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 107489 ] MariaDB v4 [ 157648 ]

            People

              anel Anel Husakovic
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.