[Bug] Can not granted user to role: operator

[xlostpath]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.0.13

What's Wrong?

CREATE USER "root"@'172.16.10.%' IDENTIFIED BY '' DEFAULT ROLE 'operator':
SQL ERROR [5064] [42000]: errCode = 2, detailMessage = Can not create root user

CREATE USER "admin"@'172.16.10.%' IDENTIFIED BY '' DEFAULT ROLE 'operator':
SQL ERROR [1105] [HY000]: errCode = 2, detailMessage = Can not granted user to role: operator

DROP USER 'root'@'%':
SQL ERROR [5064] [42000]: errCode = 2, detailMessage = Can not drop

What You Expected?

I hope to add a new user ‘root’@‘172.16.10.%’ to replace the original ‘root’@‘%’, so that only the specified IP can connect to the root user, instead of the default ‘root’@‘%’ .

How to Reproduce?

No response

Anything Else?

Unable to query which users have been created in Doris at the moment.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[ixzc]

you can't drop root user, it's not allowed. by the way, why do you wnat ot use ‘root’@‘172.16.10.%’ ? what's you specific ip of your FE node?

[xlostpath]

By default, the root user of Doris can be connected by all IPs. My intention is to make it possible for the root user to be accessed only via the IPs in the network segment of 172.16.10.%. I don't want to delete the root user. I'm just trying to create the user "root"@'172.16.10.%', but Doris doesn't allow it, so I've decided to try deleting it.