"ALL PRIVILEGES", "ON xxx.*" is not recognized during SELECT privilege verification

[RaigorJiang]

Bug Report

Related to #32044

Which version of ShardingSphere did you use?

5.5.2-SNAPSHOT master f23d908

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Expected behavior

The user has sufficient privilege and register storage unit should succeed

Actual behavior

Missing required privilege(s) SELECT ON DATABASE

Reason analyze (If you can)

No match for "ALL PRIVILEGES", "ON xxx.*"

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

1. Create mysql user with privilege

CREATE USER 'jeffrey' IDENTIFIED BY '123456';

grant all privileges on demo_ds_0.* to 'jeffrey'@'%';

show grants for 'jeffrey'@'%';

2. Register storage unit in Proxy

REGISTER STORAGE UNIT ds_0 (
    URL="jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true",
    USER="jeffrey",
    PASSWORD="123456",
    PROPERTIES("maximumPoolSize"=10)
);

3. error