Re: ALTER DEFAULT PRIVILEGES FOR USER in error

--0000000000008f683d05786d0385
Content-Type: text/plain; charset="UTF-8"

Hi,

I don't see a  GRANT CREATE ON SCHEMA ... TO 'john';

https://www.postgresql.org/docs/10/static/sql-grant.html

"For schemas, allows new objects to be created within the schema. To rename
an existing object, you must own the object and have this privilege for the
containing schema."

Benoit.

--0000000000008f683d05786d0385
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<br><br>I don&#39;t see a =C2=A0GRANT CREATE ON SCHEMA =
... TO &#39;john&#39;;<br><br><a href=3D"https://www.postgresql.org/docs/10=
/static/sql-grant.html">https://www.postgresql.org/docs/10/static/sql-grant=
.html</a><br><br>&quot;For schemas, allows new objects to be created within=
 the schema. To rename an existing object, you must own the object and have=
 this privilege for the containing schema.&quot;<br><br>Benoit.</div>

--0000000000008f683d05786d0385--