[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    =?UTF-8?Q?Issue_on_public_sch=C3=A9ma_with_Pg=5Frestore?=
From:       Thomas Poty <thomas.poty () gmail ! com>
Date:       2018-04-25 18:07:30
Message-ID: CAN_ctnjgjCvAM+L4ZTg+sh6wGVMAzjZwR9m1_4vMVKSTB7n-FA () mail ! gmail ! com
[Download RAW message or body]

Hello,
 Here is the context :
I have a db db1 with a sch=C3=A9ma public on cluster C1.
This sch=C3=A9ma doesn't have any privileges on public role.
I have a dump of this db.
On an other cluster C2, the template1 doesn't contain schema public.
I have restored db1  on cluster C2 and i saw public role had the privilege
create on the sch=C3=A9ma public.

I cannot explain this

Thank you.

Thomas?

[Attachment #3 (text/html)]

<div dir="auto">Hello,<div dir="auto">  Here is the context :</div><div dir="auto">I \
have a db db1 with a schéma public on cluster C1.</div><div dir="auto">This schéma \
doesn&#39;t have any privileges on public role.  </div><div dir="auto">I have a dump \
of this db.</div><div dir="auto">On an other cluster C2, the template1 doesn&#39;t \
contain schema public.</div><div dir="auto">I have restored db1   on cluster C2 and i \
saw public role had the privilege create on the schéma public.</div><div \
dir="auto"><br></div><div dir="auto">I cannot explain this</div><div \
dir="auto"><br></div><div dir="auto">Thank you.  </div><div dir="auto"><br></div><div \
dir="auto">Thomas?  </div><div dir="auto"><br></div><div dir="auto"><br></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]