Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kqItp-0004fG-HT for pgsql-admin@arkaria.postgresql.org; Fri, 18 Dec 2020 16:46:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kqItn-0000Fu-MT for pgsql-admin@arkaria.postgresql.org; Fri, 18 Dec 2020 16:46:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kqItn-0000Fn-Cd for pgsql-admin@lists.postgresql.org; Fri, 18 Dec 2020 16:46:35 +0000 Received: from mail-oi1-x236.google.com ([2607:f8b0:4864:20::236]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kqItk-0001hD-Eo for pgsql-admin@lists.postgresql.org; Fri, 18 Dec 2020 16:46:35 +0000 Received: by mail-oi1-x236.google.com with SMTP id 9so3465697oiq.3 for ; Fri, 18 Dec 2020 08:46:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=Vz1glWd7uTpacHFtv3BD71cTkJGjhDF7G1CfztJLgVg=; b=DDPo7d4LTXZwZ7NrFXnEfpYr7t4Go5uAuIMY9Upprvvh5ttoq8a9GjM+hvIiJQpDTL yWwES3zDBvc8QGg4PBWHn1nCVG4re0bWmSxUqAxYSwMvsYxjvyP7ZDb1mx1FqA04x1Rr YbIm2ScmkBwU/BP04sWCmddh2pZtAiWBIOcNUndDDAcU55VTB2FsTgcAVqdDTQckFKYV A8YvqDn1bSRtiQHLVYA/8erUzNFW9mvoABp3kBOwU9OU9CYxMyD3m2rgMPfAPbfcwZDS 5AEruHtr85uOspkph4sA7L0qT9fEhb+GMvw9rB3T15ByZ1b9J8BZPSoowFETxvDyKQ4m xmAw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=Vz1glWd7uTpacHFtv3BD71cTkJGjhDF7G1CfztJLgVg=; b=RxNkXg09X/XRtlAbJpOkRIABD0A01qNb+GwcobAEop1QdIgt8bXe3rgZ/RKIdVtzzO bFnCQ5KAr5Mc0cDz3GKIMQqTJwGlDWwo/vGeJAqQQy/ZwzCQOF7DtRXMxE1qvQ3y6LKE Z5Ff556hhjfsciMmbNbRdDopqM8GWZy4pNSzU2mEnx4+7TLftFhhnO2dOa7jF3y1sCp1 AVnIRDK4/YU87eCRqfmqxmRs1+9njfTi41bWdbsPlLkIqSHBPBN0carYxArzSb7ifbmo YF1uEy6TIaPdkIJaBIKwM8n0MOsqlQ0sI6Fvk6MN/27PNaVrr9/DNiAdrXVC8I3UAX0/ MxvA== X-Gm-Message-State: AOAM531NuKkqLDsQksmfdz+SYZUilojOgQxhP7qdJTXKeny9uPGm/pyA GTQYf2E5LIzgOarzetZN08Al71R6y+ArMA== X-Google-Smtp-Source: ABdhPJyVwkmnvx9uycvQQfdXGiEgxezpSzxtMMNseG4a4QYXsTjO20kZ7awNk7AYMPceYBxODyuU2g== X-Received: by 2002:aca:cfc2:: with SMTP id f185mr3318813oig.136.1608309989705; Fri, 18 Dec 2020 08:46:29 -0800 (PST) Received: from [192.168.1.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id y84sm1925132oig.36.2020.12.18.08.46.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 18 Dec 2020 08:46:28 -0800 (PST) Subject: Re: Grant request To: pgsql-admin@lists.postgresql.org References: <20201218162030.GD16415@tamriel.snowman.net> From: Ron Message-ID: <760ec38b-a424-dfae-ac1f-ce0146771fd1@gmail.com> Date: Fri, 18 Dec 2020 10:46:28 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <20201218162030.GD16415@tamriel.snowman.net> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/18/20 10:20 AM, Stephen Frost wrote: > Greetings, > > * Ron Watkins (rwatki@gmail.com) wrote: >> I have a Azure production server, and a group of users is requesting select >> permissions for all tables, views, sequences, etc. >> This is for all existing and all new objects in all schemas in the database. >> I don't see any kind of "db_datareader" role. Suggestions? > https://commitfest.postgresql.org/31/2702/ > > Hopefully will be included in PG14. Would be great to have folks who > have this requirement take a look at and play with that patch and make > sure that the role meets your requirements. It's a darned shame this bug patch won't be applied to PG12. -- Angular momentum makes the world go 'round.