Read only to schema

From: Łukasz Jarych <jaryszek(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Read only to schema
Date: 2018-07-13 05:00:24
Message-ID: CAGv31odWvR7=_VPR=wVNkK3nNh5EHfEyEuMSUHW0TNFdHVjnXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Guys,

Yesterday i tried all day to figure out system to read only schemas.

I want to :

1. Create user who can login (user: jaryszek)
2. Create role who can read only data (only watching tables) (role:
readonly)
3, Create role who can read all data (inserting, deleting, altering,
dropping) (role: readall)

What sqls should i use for this?
What grants should i add?

And now i am logged as jaryszek

I want to grant myself role read only to schema public (when owner is
postgres).
I want to review tables as views only,
After work i want to grant myself role readall to schema public.

It is possible?
Or possible workaround ?

Best,
Jacek

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2018-07-13 05:19:57 RE: Read only to schema
Previous Message Adrian Klaver 2018-07-13 01:23:17 Re: How to watch for schema changes