pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Kaushal Shriyan <kaushalshriyan@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Grant all privileges to user on a database
Date: Mon, 24 Jul 2023 10:09:06 -0400
Message-ID: <1549849.1690207746@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwaJ=zeoBjdh9pMMWN34Y-rdhc4xmvT37YKWuBZcNjYR2Q@mail.gmail.com>
References: <CAD7Ssm9fFBRN0+YssRgXmx7yECsunDg7kL_r2Yowh-3iD9tFTw@mail.gmail.com>
	<85b5b466-1efd-fb89-8686-08e5df88a00b@gmail.com>
	<CAD7Ssm8yFSywuKZVyPsn94_-Y9Pzo_nq7_3kfjSYOwhZBuCubA@mail.gmail.com>
	<CAKFQuwaJ=zeoBjdh9pMMWN34Y-rdhc4xmvT37YKWuBZcNjYR2Q@mail.gmail.com>

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> The error message is misleading, you can’t directly create tables in a
> database, you must create them in a schema and the permission to do so is
> granted to the role on the schema, not the database.

The actual server message is going to be just

ERROR:  permission denied for schema public

I'm not sure where the "Are you sure ..." bit came from, but it wasn't
Postgres.

Anyway, backing up two steps, it looks like drupal hasn't yet adapted
to the v15 change that removed default create privileges on the public
schema (for security reasons).  You might see if a newer drupal release
is available.  If not, the best bet would likely be

GRANT ALL ON SCHEMA public TO public;

If you run into more problems, a more drastic answer might be to
downgrade to whatever drupal considers a supported release of
Postgres.

			regards, tom lane





view thread (7+ messages)  latest in thread

Message-ID: <1549849.1690207746@sss.pgh.pa.us>
Permalink:  ../1549849.1690207746@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1549849.1690207746@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, kaushalshriyan@gmail.com, ronljohnsonjr@gmail.com
  Subject: Re: Grant all privileges to user on a database
  In-Reply-To: <1549849.1690207746@sss.pgh.pa.us>
  References: <CAD7Ssm9fFBRN0+YssRgXmx7yECsunDg7kL_r2Yowh-3iD9tFTw@mail.gmail.com> <85b5b466-1efd-fb89-8686-08e5df88a00b@gmail.com> <CAD7Ssm8yFSywuKZVyPsn94_-Y9Pzo_nq7_3kfjSYOwhZBuCubA@mail.gmail.com> <CAKFQuwaJ=zeoBjdh9pMMWN34Y-rdhc4xmvT37YKWuBZcNjYR2Q@mail.gmail.com> <1549849.1690207746@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox