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

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-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-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-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-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-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 Łukasz Jarych
I found something like this: CREATE ROLE readonly_user WITH LOGIN ENCRYPTED PASSWORD '1234' ALTER ROLE readonly_user SET search_path to public GRANT CONNECT ON DATABASE "TestDb" TO readonly_user; GRANT USAGE ON SCHEMA public TO readonly_user; GRANT USAGE ON AL

Re: Read only to schema

2018-07-13 Thread Łukasz Jarych
Maybe read-only view? Best, Jacek pt., 13 lip 2018 o 07:00 Łukasz Jarych 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 table

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 : Here is