| 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: | Whole Thread | Raw Message | 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 |