Postgres Pro
Downloads
Home   >   mailing lists

Re: List out the users having access (read/write) on a specific table - Mailing list pgsql-admin

From Dhanraj Acharya
Subject Re: List out the users having access (read/write) on a specific table
Date
Msg-id CALjUFsEdLtd5=_=zsUCsm_t7sbVRjSEiW1WHaw9+VRMs+wLiBA@mail.gmail.com
Whole thread Raw
In response to List out the users having access (read/write) on a specific table  (Shrikant Bhende <shrikantpostgresql@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Shrikant Bhende
Date:
Subject: List out the users having access (read/write) on a specific table
Next
From: Yambu
Date:
Subject: pgadmin 4 dashboard