[Bug] Grant hive catalog not take effect

[sangetang]

Search before asking

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

Version

2.1.8-1

What's Wrong?

New user query hive catalog access denied

What You Expected?

User query "SELECT * FROM hive.cdm_abite.dim_spu limit 20" is ok!

How to Reproduce?

1. CREATE CATALOG hive PROPERTIES (

"type"="hms",
"hive.metastore.type" = "dlf",
"dlf.proxy.mode" = "DLF_ONLY",
"dlf.endpoint" = "dlf-vpc.cn-beijing.aliyuncs.com",
"dlf.region" = "cn-beijing",
...
2. CREATE USER test@'%' IDENTIFIED BY 'test123';
3. GRANT SELECT_PRIV ON hive.cdm_abite.* TO 'test'@'%';
4. [user test] SWITCH hive
5. USE cdm_abite; Err: errCode = 2, detailMessage = Access denied for user 'test' to database 'cdm_abite'
6. [user root] SWITCH hive
7. "SELECT * FROM hive.cdm_abite.dim_spu limit 20" is ok!

Anything Else?

No response

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