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

From: Dhanraj Acharya <dhanraj(dot)acharya(at)gmail(dot)com>
To: Shrikant Bhende <shrikantpostgresql(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: List out the users having access (read/write) on a specific table
Date: 2020-11-09 07:36:42
Message-ID: CALjUFsEdLtd5=_=zsUCsm_t7sbVRjSEiW1WHaw9+VRMs+wLiBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2020-11-09 08:22:51 pgadmin 4 dashboard
Previous Message Shrikant Bhende 2020-11-09 07:08:36 List out the users having access (read/write) on a specific table