Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Shrikant Bhende
Date:
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 

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

From
Dhanraj Acharya
Date:
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