Re: Permissions for Web App

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permissions for Web App
Date: 2017-10-09 17:51:46
Message-ID: CAKFQuwah90Bk4OoPShoqophOHf-Gh+ymQDZ2hyHwqgYWG50iCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 9, 2017 at 9:44 AM, Igal @ Lucee.org <igal(at)lucee(dot)org> wrote:

> But I want to give that role permissions on future tables since I add new
> tables and drop/recreate current ones.
>

​ALTER DEFAULT PRIVILEGES​

​https://www.postgresql.org/docs/9.6/static/sql-alterdefaultprivileges.html

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Mead 2017-10-09 18:02:12 Re: Using cp to back up a database?
Previous Message David G. Johnston 2017-10-09 17:33:42 Re: pg_start/stop_backup naming conventions