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

Wrong error code/message ER_INVALID_ROLE on setting a default role for non-existing user

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.1.1
    • 10.1(EOL)
    • OTHER
    • None

    Description

      MariaDB [test]> create role r1;
      		 
      Query OK, 0 rows affected (0.00 sec)
      		 
       
      		 
      MariaDB [test]> set default role r1 for non_existing_user;
      		 
      ERROR 1959 (OP000): Invalid role specification `r1`.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26875 Wrong user in SET DEFAULT ROLE error

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Field Original Value New Value
            Workflow MariaDB v2 [ 56900 ] MariaDB v3 [ 65292 ]
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            ralf.gebhardt Ralf Gebhardt added a comment -

            Error code in 10.5.6
            ERROR 1959 (OP000): User `non_existing_user@%` has not been granted role `r1`

            ralf.gebhardt Ralf Gebhardt added a comment - Error code in 10.5.6 ERROR 1959 (OP000): User `non_existing_user@%` has not been granted role `r1`
            markus makela markus makela made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 65292 ] MariaDB v4 [ 139715 ]

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.