Restrict Write Users

From: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Restrict Write Users
Date: 2023-06-20 11:23:11
Message-ID: VI1PR10MB76716A9822F3326AF01E545C8D5CA@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

Is there a way to restrict write access to a user by restricting the user to have read-only on other databases on the instance. I'm using postgresql-14 version

Regards,
Phani Pratz
PPBET-DBA

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bhasker Bathini 2023-06-20 11:33:10 Why do i need to install set_user extension if i can directly grant all required privileges to user?
Previous Message Laurenz Albe 2023-06-20 10:49:04 Re: What does invalid_transaction_state 25000 mean