Re: CREATE ANY TABLE privileges, etc

From: Don Seiler <don(at)seiler(dot)us>
To: Keith <keith(at)keithf4(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: CREATE ANY TABLE privileges, etc
Date: 2017-08-15 14:30:40
Message-ID: CAHJZqBA8Ge078y7fum30vBDBrRtg2YX2WPqCWHc7MamR7NA1DA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Aug 15, 2017 at 9:08 AM, Keith <keith(at)keithf4(dot)com> wrote:
>
>
> Easiest thing would be to grant ownership of that database to the user.
> That won't grant privileges to any existing objects, but will allow new
> schemas to be made by that user, which will in turn allow objects to be
> made in those schema that user creates.
>

I ended up granting the role that owns the DB to the user. Sounds similar
to what you suggested? I'm waiting to hear from the dev if it does what he
needs.

Thanks,
Don.
--
Don Seiler
www.seiler.us

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Phil Frost 2017-08-15 14:56:27 Re: avoiding split brain with repmgr
Previous Message Keith 2017-08-15 14:08:29 Re: CREATE ANY TABLE privileges, etc