Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Why can't the database owner create schemas and how can I enable that? - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Why can't the database owner create schemas and how can I enable that?
Date
Msg-id 25309.1506181312@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Why can't the database owner create schemas and how canI enable that?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
John R Pierce <pierce@hogranch.com> writes:
> On 9/22/2017 10:29 PM, Tim Uckun wrote:
>> The app can now connect to the database but it can't create any 
>> tables, schemas or anything else unless I give it superuser privileges.

> that should have worked just fine.

Yeah.  Note that creating new schemas is not directly connected to
ownership anyway --- it's a question of whether you have the CREATE
privilege on the database.  The owner should have that privilege
by default, but it could be revoked, or granted to others.
        regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Paul A Jungwirth
Date:
Subject: Re: [GENERAL] Is float8 a reference type?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Adding Cyrillic support