Predefined Role - pg_write_all_data

From: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Predefined Role - pg_write_all_data
Date: 2023-10-25 15:00:22
Message-ID: CAHOGQfXpTeV74KpUYdRxYgsHrxp3pptwWtXw66Kp+WhuzSkNDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Please help me to understand if we grant pg_write_all data role to some
user then does that user get ability to do DML operations on system
catalogs and system views.

if yes then how we can restrict them.

--
Thanks & Regards
Gambhir Singh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-10-25 17:51:10 Re: User/Roles, Owner, and privileges migration strategy
Previous Message Rajesh Kumar 2023-10-25 11:36:00 Re: Autovacuum and Insert wait