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 1pRn7B-0007pM-Aw for pgsql-general@arkaria.postgresql.org; Tue, 14 Feb 2023 04:40:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pRn79-00053z-Cn for pgsql-general@arkaria.postgresql.org; Tue, 14 Feb 2023 04:40:23 +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 1pRn79-00053q-1z for pgsql-general@lists.postgresql.org; Tue, 14 Feb 2023 04:40:23 +0000 Received: from mail-pl1-x62c.google.com ([2607:f8b0:4864:20::62c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pRn72-0002vI-HW for pgsql-general@lists.postgresql.org; Tue, 14 Feb 2023 04:40:22 +0000 Received: by mail-pl1-x62c.google.com with SMTP id m2so15822163plg.4 for ; Mon, 13 Feb 2023 20:40:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=C7/G5TYntX0b6t8L3goNS+cUL36ifdCjW1yUXekupWg=; b=MsasluyCXWEDlMeJl6Ya63es6lz9fctvFHxcY0GWXFApq6FLDdvUpB67auIxVJ+m5Y nn3lIvKqCGpJSEOWECvyNTO0YhEaK6tn2GNmAOAjaI/ZBKnxBtuSkmic8B1yST4Ix+25 hv4Eo6BSwHVvCYeQjHzog+NOUAZaBzykjvkSPHReOJ6qmjb6BKhTdAMWxhbtTZ82ANw5 XUecmN7Jg4lgNjDaJHBrQl/cX40tiqJ42HvY2CNYpADOIXh/QOYOD7/Y3jV7z9LVR4s+ L2m+iV9OTEWy0qTg7r+FaMC0vUXGt3uRzfT8ZKnxwD4h4qN452j/5roJA1vzdA/cNzJa k/uA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=C7/G5TYntX0b6t8L3goNS+cUL36ifdCjW1yUXekupWg=; b=3eJ8l4Y7JiP2E5napXnYZjFCe8q1Y6o0pcf+08oweUaFfFrH2Z0p3FYhrWLmdoqvnN 1CJfOPSh2YNR0ADsep0x0Jv+5tT3ZNfhlZNkyCZSWR1Zd9tq+5IC2aZ+qO7BIM6Cgxc4 4FNbsls6SCS6jjfy3jlGL+uzDwLy6B5L1DMDEKHzZuPJ+hz88V5pGszfT1+neewU2kGR hsj2l6r0qf18Kt9kUtVhUwG7RuqXSryBXxSXNCSFEAtR45pUAuihHs+RD/tShnE4r/b+ qxTEiM1gF3UHcnN4+ILukyjn9HAziadM7bl5u1MTagtveyQRxvpNpmuR5qpcd0BzcJz4 iH3g== X-Gm-Message-State: AO0yUKUXRNwV1K3zu1d5XM6Oza1KjJADw3Ty4xnq2HpBLopD64ixGQS5 40gT+AHZyWZqnpqt03d3z2L4ildt59w= X-Google-Smtp-Source: AK7set/EORIOxlIBjgY4FMHwS8l69O7DFT9dYgd8AHa8RGAUz/iMEPCpsQASAouYidO06lWKLqT3HQ== X-Received: by 2002:a17:90a:7c41:b0:230:3af9:174 with SMTP id e1-20020a17090a7c4100b002303af90174mr16907455pjl.5.1676349613825; Mon, 13 Feb 2023 20:40:13 -0800 (PST) Received: from ?IPV6:2601:681:5a00:f790:bea3:2a94:46b5:7f1d? ([2601:681:5a00:f790:bea3:2a94:46b5:7f1d]) by smtp.gmail.com with ESMTPSA id q16-20020a17090ad39000b0022c9eddaf9dsm3080191pju.0.2023.02.13.20.40.12 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 13 Feb 2023 20:40:13 -0800 (PST) Content-Type: multipart/alternative; boundary="------------eKpl4UuazZ0GU0LMWyIAnRpk" Message-ID: <3b71a108-70c0-0e2b-e6d3-30b22edc9c82@gmail.com> Date: Mon, 13 Feb 2023 21:40:12 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.7.1 Subject: Re: HOWTO? Permissions for user to access a single db Content-Language: en-CA To: pgsql-general@lists.postgresql.org References: <40bf6627-747b-3fa5-faa4-ca2b1b676026@aklaver.com> From: Rob Sargent In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------eKpl4UuazZ0GU0LMWyIAnRpk Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2/13/23 21:35, Damian Carey wrote: > Tom, Rob & Adrian, > > I understand exactly what each of you are getting at, but instead of > fumbling and further wasting your time I'm going to get a freelancer > to smash out a suitable setup sans beginner mistakes. It's a pretty > basic problem for a learned colleague. > > I've clearly thrived in my safely walled PG garden for too long to > sort this basic stuff. Our Linux consultant is top notch, but PG's not > his core skill. > > Appreciate you all taking the time. Wish I could have asked a more > satisfying question with a neat and useful solution :-) > > Huge thx. > > -Damian OK, gone there too!  Hope you find someone whose company also helps out here. There are consultants nearby --------------eKpl4UuazZ0GU0LMWyIAnRpk Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 2/13/23 21:35, Damian Carey wrote:
Tom, Rob & Adrian,

I understand exactly what each of you are getting at, but instead of fumbling and further wasting your time I'm going to get a freelancer to smash out a suitable setup sans beginner mistakes. It's a pretty basic problem for a learned colleague.

I've clearly thrived in my safely walled PG garden for too long to sort this basic stuff. Our Linux consultant is top notch, but PG's not his core skill.

Appreciate you all taking the time. Wish I could have asked a more satisfying question with a neat and useful solution :-)

Huge thx.

-Damian

OK, gone there too!  Hope you find someone whose company also helps out here. There are consultants nearby

--------------eKpl4UuazZ0GU0LMWyIAnRpk--