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
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 |