Feature: Add access check for management mode

[junnplus]

Summary

Before we remove access check in #4616, but considering that we need to use management mode to process some management SQL without query node, like create a database. Parsing management SQL on the gateway is tricky, so let's add it back.