) (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
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 :
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
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
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
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
> *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
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!
:* 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
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
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
11 matches
Mail list logo