| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'Sumeet Shukla *EXTERN*'" <sumeet(dot)k(dot)shukla(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: List all users with read write access on a PG server with multiple database and objects |
| Date: | 2017-04-19 07:28:30 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B53A279FB@ntex2010i.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Sumeet Shukla wrote:
> Can someone please help me in finding the list of users who has read-write access on any
> of the database objects. Member roles are used to grant access to users. Please note the
> server has many databases and objects.
>
> Please let me know if I need to provide more details.
I cannot provide you with a ready-made script, but you'll have to
connect to all databases in turn and evaluate the privileges.
The access privilege inquiry functions are described here:
https://www.postgresql.org/docs/current/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
These should make the task simpler than digging through all
role memberships yourself.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2017-04-19 08:12:43 | Re: Question about pg_xlog |
| Previous Message | Sumeet Shukla | 2017-04-19 04:35:25 | List all users with read write access on a PG server with multiple database and objects |