[MDEV-6967] Wrong error code/message ER_INVALID_ROLE on setting a default role for non-existing user Created: 2014-10-28  Updated: 2021-10-21

Status: Open
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.1.1
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26875 Wrong user in SET DEFAULT ROLE error Closed

 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`.



 Comments   
Comment by Ralf Gebhardt [ 2020-10-27 ]

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

Generated at Thu Feb 08 07:15:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.