Re: List out the users having access (read/write) on a specific table

Поиск
Список
Период
Сортировка
От Dhanraj Acharya
Тема Re: List out the users having access (read/write) on a specific table
Дата
Msg-id CALjUFsEdLtd5=_=zsUCsm_t7sbVRjSEiW1WHaw9+VRMs+wLiBA@mail.gmail.com
обсуждение исходный текст
Ответ на List out the users having access (read/write) on a specific table  (Shrikant Bhende <shrikantpostgresql@gmail.com>)
Список pgsql-admin
Дерево обсуждения
HI,

Please try below query

 select * from  information_schema.role_table_grants where table_name = 'tablename'

On Mon, Nov 9, 2020 at 12:38 PM Shrikant Bhende <shrikantpostgresql@gmail.com> wrote:
Hello, 

How can I get the list of all the users having read or write access on a particular table, 
for example, I need to find out the list of users having access on table "test_schema.xyz". 


Thanks 

В списке pgsql-admin по дате отправления: