Restrict Write Users - Mailing list pgsql-admin

From Phani Prathyush Somayajula
Subject Restrict Write Users
Date
Msg-id VI1PR10MB76716A9822F3326AF01E545C8D5CA@VI1PR10MB7671.EURPRD10.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Restrict Write Users
List 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

 

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: What does invalid_transaction_state 25000 mean
Next
From: Bhasker Bathini
Date:
Subject: Why do i need to install set_user extension if i can directly grant all required privileges to user?