Relative Content

Tag Archive for postgresqldatabase-administrationpostgres-14

Trouble with only read user in Postgresql

I have a cluster where running around 20 postgres databases. I need to create read only user for every db.
On this server i have service user e.g. service_user that do automaticly all operations in database like migrations, update, insert and more. And i have super user super_user that have all the privelegies.
So i need to create user on every db, that will have permissions to select only in schema public in database he belongs to, and should not see other databses, and would not have permission to create new objects.
In my case all entites belongs to service_user.