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: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permissions for Web App
Date: 2017-10-13 18:21:22
Message-ID: CAKFQuwYjjwpaXRRzpf9pn5YRXSnAGBWOQ444BukMUSxDvno+mw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 13, 2017 at 11:03 AM, Igal @ Lucee.org <igal(at)lucee(dot)org> wrote:

> You mean that if I execute the ALTER DEFAULT command above as user
> `postgres` then only tables created by user `postgres` will give default
> privileges to role `webapp`?
>

​Yes. "​You can change default privileges only for objects that will be
created by yourself or by roles that you are a member of."

You use the "FOR <target_role>" modifier if you want the "or by roles that
you are a member of" portion to be used.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2017-10-13 19:03:10 Re: "Shared strings"-style table
Previous Message David G. Johnston 2017-10-13 18:16:27 Re: "Shared strings"-style table