fix(cdc): fix privilege check for shared mysql source

fix(cdc): fix privilege check for shared mysql source #30544