On Sunday, September 11, 2022, yanliang lei <msdnch...@163.com> wrote:
> Dear everyone， > how to check specific <user_name> have “SELECT ON ALL TABLES IN SCHEMA > <tableschema>” privilege or not ? > This is not an appropriate list to ask general usage questions. We have a -general list for those. But, that isn’t a privilege. Its a grant action. The privilege is just select on a table in a schema. So you have to check every table in the schema individually. The functions and the catalogs documented to retrieve this information - start putting them together into a query. I’m unable to go look for the specific details right now. David J.
