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

[Dhanraj Acharya <dhanraj.acharya@xxxxxxxxx>]

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@xxxxxxxxx> 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