Re: ALTER DEFAULT PRIVILEGES FOR USER in error

From: talk to ben <blo(dot)talkto(at)gmail(dot)com>
To: etienne(dot)decherf-ext(at)aphp(dot)fr
Cc: pgsql-fr-generale(at)lists(dot)postgresql(dot)org
Subject: Re: ALTER DEFAULT PRIVILEGES FOR USER in error
Date: 2018-10-17 13:52:57
Message-ID: CAPE8EZ6EkEwKXcDqhGZF+q-N3o57u24abAdXebNN18UkpD49=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

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.

In response to

Browse pgsql-fr-generale by date

  From Date Subject
Next Message DECHERF Étienne 2018-10-19 16:20:35 PG V9.6 / REVOKE SELECT columns ON TABLE T1 FROM John
Previous Message DECHERF Étienne 2018-10-17 13:40:49 ALTER DEFAULT PRIVILEGES FOR USER in error