Read only to schema

2018-07-12 Thread Łukasz Jarych
) (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

RE: Read only to schema

2018-07-12 Thread Charles Clavadetscher
Hello From: Łukasz Jarych [mailto:jarys...@gmail.com] Sent: Freitag, 13. Juli 2018 07:00 To: pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Read only to schema Hi Guys, Yesterday i tried all day to figure out system to read only schemas. I want to :

Re: Read only to schema

2018-07-13 Thread Łukasz Jarych
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

Re: Read only to schema

2018-07-13 Thread Łukasz Jarych
o : >> >> 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

RE: Read only to schema

2018-07-13 Thread Charles Clavadetscher
Hello From: Łukasz Jarych [mailto:jarys...@gmail.com] Sent: Freitag, 13. Juli 2018 16:39 To: pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Re: Read only to schema I found something like this: CREATE ROLE readonly_user WITH LOGIN ENCRYPTED PA

RE: Read only to schema

2018-07-13 Thread Charles Clavadetscher
An addition to my previous post (marked as [addition]). From: Charles Clavadetscher [mailto:clavadetsc...@swisspug.org] Sent: Samstag, 14. Juli 2018 08:23 To: 'Łukasz Jarych' ; pgsql-gene...@postgresql.org Subject: RE: Read only to schema Hello From: Łukasz Jarych [ma

Re: Read only to schema

2018-07-14 Thread Łukasz Jarych
> *To:* pgsql-gene...@postgresql.org >> PG-General Mailing List < > pgsql-gene...@postgresql.org> > *Subject:* Re: Read only to schema > > > > I found something like this: > > > > CREATE ROLE readonly_user > >WITH LOGIN > >ENCRYP

RE: Read only to schema

2018-07-14 Thread Charles Clavadetscher
Hello Jacek From: Łukasz Jarych [mailto:jarys...@gmail.com] Sent: Samstag, 14. Juli 2018 11:55 To: clavadetsc...@swisspug.org; pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Re: Read only to schema Thank you very much Charles! Awesome knowledge, thank you!

Re: Read only to schema

2018-07-25 Thread Łukasz Jarych
:* Samstag, 14. Juli 2018 11:55 > *To:* clavadetsc...@swisspug.org; pgsql-gene...@postgresql.org >> > PG-General Mailing List > *Subject:* Re: Read only to schema > > > > Thank you very much Charles! > > > > Awesome knowledge, thank you! > > > > I will test it

RE: Read only to schema

2018-07-28 Thread Charles Clavadetscher
Hello Jakek From: Łukasz Jarych [mailto:jarys...@gmail.com] Sent: Samstag, 28. Juli 2018 14:13 To: Melvin Davidson ; pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Re: Read only to schema Hi Guys, thank you for such advances replies and help ! You are th

Re: Read only to schema

2018-07-28 Thread Łukasz Jarych
ostgresql.org > >> PG-General Mailing List > *Subject:* Re: Read only to schema > > > > Hi Guys, > > > > thank you for such advances replies and help ! You are the best! > > > > I have found out that this command: > > > > *GRANT ALL PRIVILAGES