Maybe read-only view?
Best,
Jacek
pt., 13 lip 2018 o 07:00 Łukasz Jarych <jaryszek@xxxxxxxxx> napisał(a):
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 jaryszekI 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