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 1pMg7X-0007Y2-Ba for pgsql-admin@arkaria.postgresql.org; Tue, 31 Jan 2023 02:11:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pMg7V-00075U-I7 for pgsql-admin@arkaria.postgresql.org; Tue, 31 Jan 2023 02:11:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pMg7V-00074x-3r for pgsql-admin@lists.postgresql.org; Tue, 31 Jan 2023 02:11:37 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pMg7T-00009L-2x for pgsql-admin@lists.postgresql.org; Tue, 31 Jan 2023 02:11:36 +0000 Received: by mail-pj1-x102a.google.com with SMTP id cq16-20020a17090af99000b0022c9791ac39so5130364pjb.4 for ; Mon, 30 Jan 2023 18:11:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=C5u1k66iN0ZZ4hRFylLhkERLXGx3l4dGocckghT1B7A=; b=VYYobssiV5j4xEs/b5+YjVJon56b+4MEBi+YIeaU1OG3w57zt6gNxCA5WcOIXBBRCn WI9TO6G8Rmaxa/MPJtRIlyGfpbYGRh/ecV4GFuPsXI0jaU36/s6u7+hm3M/m94R1qBKf uqxo05hXxH7dRk/qjlSW96fM9iEF1+EaXmuf47TvxZV7ZGtpZlkvU/1Ni+WjopwKg6a1 3fv3lilCXHYIKXNbtZGU2QrEtXC75FAbtXr+y97rGz3v2lUgTUXGbPTigYRiRpKs691Q pQCWSZOgRD3t6X4NGWZO1LbSiPVg10VFq5OW1ZtNgw4SnUjAEM2+G8XLsGx5xMpLtRGE 67Nw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=C5u1k66iN0ZZ4hRFylLhkERLXGx3l4dGocckghT1B7A=; b=a4ivvUXHTiUFGURZtXPJDJl6ULt5eIykpMwN3acGE4sj4E2EI9ZbnjqcOsjY6x+iZh 6dudRMJizQAOhSzLivfg2jSn+p2e7CJ3Zzj7NXqXTy7JFagbmMelfHZyPUF4p4mKwMF5 a+DzEiMj42MVdt0maUk8ql6TM4oNe3gCIEhcOdHht/GVPBnKRy4ALac89EttWkZ6Y99g jDAXS2HxTEicwKv7FPCq8UEKsY5yN91YFY5AK4RSDsmCt5DMkaXbaRtCUbdIDayvnQwg b9thpNSktcY5uKlJwPD5gs2gC01ePS1Gz2T+RWHDrz8hdOiMx7atnoRuoOj7mjzSmj7x Vi1A== X-Gm-Message-State: AO0yUKU9fpIKRRXShNHmNzLP+iZMR+8YSFoVInWcZfMFY0LaYrVBF6Ko MqBPr9bV5BthnAUyz0EG4riZBoQ8K9A= X-Google-Smtp-Source: AK7set+5PuLsjKpNiSRCTSTep3/qE39QeFx/lu4wa4ky9XsyaneaiqSq7Zbv+keupIWcF+EH4IauSg== X-Received: by 2002:a05:6a21:6d81:b0:bc:70f6:f537 with SMTP id wl1-20020a056a216d8100b000bc70f6f537mr15613079pzb.15.1675131093707; Mon, 30 Jan 2023 18:11:33 -0800 (PST) Received: from smtpclient.apple (2603-8001-0200-0026-88b4-7772-0a21-b12c.res6.spectrum.com. [2603:8001:200:26:88b4:7772:a21:b12c]) by smtp.gmail.com with ESMTPSA id gf17-20020a17090ac7d100b0021904307a53sm7740673pjb.19.2023.01.30.18.11.32 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 30 Jan 2023 18:11:33 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-298FF112-5C18-46DE-BAD8-11449272046A Content-Transfer-Encoding: 7bit From: Teja Jakkidi Mime-Version: 1.0 (1.0) Subject: Re: user permission denied for schema Date: Mon, 30 Jan 2023 18:11:21 -0800 Message-Id: <931FA0FE-62CE-43F4-828F-C13F6BA4D664@gmail.com> References: Cc: pgsql-admin@lists.postgresql.org In-Reply-To: To: Ankur Kaushik X-Mailer: iPhone Mail (20C65) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-298FF112-5C18-46DE-BAD8-11449272046A Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello Kaushik, Did you grant usage on schema to the user?? Grant usage on schema schemaname to username; Thanks, Teja. J. > On Jan 30, 2023, at 6:08 PM, Ankur Kaushik wrote:= >=20 > =EF=BB=BF >=20 > Hi, >=20 > I am trying to select records from table for other schema but unable to fe= tch due to permission denied error >=20 > GRANT SELECT ON ALL TABLES IN SCHEMA condenastvms_uat TO edw; >=20 > sdp_edw=3D> select count(*) from condenastvms_uat.activity_logs; > ERROR: permission denied for schema condenastvms_uat > LINE 1: select count(*) from condenastvms_uat.activity_logs; >=20 > Regards > Ankur >=20 >=20 --Apple-Mail-298FF112-5C18-46DE-BAD8-11449272046A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello Kaushik,

Did you g= rant usage on schema to the user??

Grant usage on s= chema schemaname to username;

Thanks,
Teja. J.

= On Jan 30, 2023, at 6:08 PM, Ankur Kaushik <ankurkaushik@gmail.com> wr= ote:

=EF= =BB=BF

Hi,

I am trying to s= elect records from table for other schema but unable to fetch due to permiss= ion denied error

GRANT SELECT ON ALL TABLES IN SCHEM= A condenastvms_uat TO edw;


sdp_edw=3D> select count(*) from= condenastvms_uat.activity_logs;

ERROR:  permission denied for schema condenastvms_uat

LINE 1: select count(*) from conden= astvms_uat.activity_logs;

<= span class=3D"gmail-s1" style=3D"font-variant-ligatures:no-common-ligatures"= >

Regards

<= p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-va= riant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:norma= l;font-family:Menlo;color:rgb(0,0,0)">Ankur


<= span class=3D"gmail-s1" style=3D"font-variant-ligatures:no-common-ligatures"= >

= --Apple-Mail-298FF112-5C18-46DE-BAD8-11449272046A--