| From: | "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Permissions for Web App |
| Date: | 2017-10-13 19:09:40 |
| Message-ID: | d8bc008c-7281-a244-5673-19c3c082d526@lucee.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/13/2017 11:21 AM, David G. Johnston wrote:
> On Fri, Oct 13, 2017 at 11:03 AM, Igal @ Lucee.org <igal(at)lucee(dot)org
> <mailto: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.
>
Thank you for clarifying,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igal @ Lucee.org | 2017-10-13 19:29:40 | Multiple Schemas vs. Multiple Databases |
| Previous Message | Seamus Abshere | 2017-10-13 19:08:57 | Re: "Shared strings"-style table |