[Bug] Incorrect privilege requirement for show transaction command #58917
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
doris 2.1.x
What's Wrong?
According to official document, show transaction command only need load priv on target database,
but in 2.1 branch it still requires admin privilege.
and according to code pr and web pr, seems it's expected to apply on both 2.1 and 3.x, but actually only merge to 3.1 branch, and not 2.1 and 3.0 branch.
What You Expected?
Only need load priv on target database to run show transaction.
How to Reproduce?
Run show transaction on <target_db> command.
Anything Else?
We need this command to check if insert or stream load transaction is not only committed but also visible in our workflow, but we should not grant admin priv to user. Any other workaround is welcome too.
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