John R Pierce <pierce@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general