Postgres Pro
Downloads
Home   >   mailing lists

Re: Grant all privileges to user on a database - Mailing list pgsql-general

From David G. Johnston
Subject Re: Grant all privileges to user on a database
Date
Msg-id CAKFQuwaJ=zeoBjdh9pMMWN34Y-rdhc4xmvT37YKWuBZcNjYR2Q@mail.gmail.com
Whole thread Raw
In response to Re: Grant all privileges to user on a database  (Kaushal Shriyan <kaushalshriyan@gmail.com>)
Responses Re: Grant all privileges to user on a database
List pgsql-general
Tree view
On Monday, July 24, 2023, Kaushal Shriyan <kaushalshriyan@gmail.com> wrote:


Are you sure the configured username has the necessary permissions to create tables in the database?

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.

David J.
 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: \d don't print all the tables
Next
From: Tom Lane
Date:
Subject: Re: Grant all privileges to user on a database