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

GRANT role TO user denied to ALL PRIVILEGES user

    XMLWordPrintable

Details

    Description

      roles.grant/grant.test

      SHOW GRANTS;
       
      CREATE USER 'bob'@'%';
      CREATE USER 'judy'@'%';
      CREATE ROLE 'role_1' WITH ADMIN 'bob'@'%';
      GRANT SELECT ON mysql.user TO 'bob'@'%';
      GRANT role_1 TO 'judy'@'%';
      GRANT role_1 TO 'bob'@'%' WITH ADMIN OPTION;
      

      results

      SHOW GRANTS;
      Grants for root@localhost
      GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
      GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
      CREATE USER 'bob'@'%';
      CREATE USER 'judy'@'%';
      CREATE ROLE 'role_1' WITH ADMIN 'bob'@'%';
      GRANT SELECT ON mysql.user TO 'bob'@'%';
      GRANT role_1 TO 'judy'@'%';
      roles.grant                              [ fail ]
              Test ended at 2020-09-25 17:59:58
       
      CURRENT_TEST: roles.grant
      mysqltest: At line 8: query 'GRANT role_1 TO 'judy'@'%'' failed: 1698: Access denied for user 'root'@'localhost'
      
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            danblack Daniel Black
            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.