Re: how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA ” 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.