Обсуждение: how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA ” privilege or not ?

Поиск
Список
Период
Сортировка

how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA ” privilege or not ?

От
"yanliang lei"
Дата:
Dear everyone,
how to check specific <user_name>  have “SELECT ON ALL TABLES IN SCHEMA <tableschema>”  privilege or not ?

Re: how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA ” privilege or not ?

От
"David G. Johnston"
Дата:
On Sunday, September 11, 2022, yanliang lei <msdnchina@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.