Postgres Pro
Downloads
Home   >   mailing lists

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

From Tim Uckun
Subject [GENERAL] Why can't the database owner create schemas and how can I enable that?
Date
Msg-id CAGuHJrOPm_VGXtVZ=+6ZPXDubCnoxJuJ0bUpfztFzjMzFxv+5g@mail.gmail.com
Whole thread Raw
Responses 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
I am setting up a database for an app. So I create a user without superuser but with login priveleges

I then create a database and set it's owner to that user like this...

dropdb --if-exists api_development
dropuser --if-exists api_user

createuser api_user -P -d
createdb api_development -O api_user

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. 

Is there any way I can make this user a superuser for this database without making it a superuser on other databases?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Is float8 a reference type?
Next
From: Vladimir Mihailenco
Date:
Subject: [GENERAL] shared_buffers smaller than max_wal_size