fix: global dml access error for non-admin user
Summary
- fix: global dml access error for non-admin user
- when doing global dml sql query, there is error like user don't have access to 'raft_state` space. Fix this by doing parts of pipeline that access system spaces under admin
- Close #711 (closed)
- Cherry-pick to: 24.4
- Docs follow-up: not necessary