On Fri, Oct 13, 2017 at 11:03 AM, Igal @ Lucee.org <igal@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.