On 10/13/2017 11:21 AM, David G. Johnston wrote:
On Fri, Oct 13, 2017 at 11:03 AM, Igal @ Lucee.org <i...@lucee.org
<mailto:i...@lucee.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/>
