Re: Permissions for Web App

"Igal @ Lucee.org" <igal@xxxxxxxxx> · Fri, 13 Oct 2017 12:09:40 -0700



    On 10/13/2017 11:21 AM, David G. Johnston wrote:

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