Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1VQZ-00Gbl4-OX for pgsql-admin@arkaria.postgresql.org; Thu, 17 Oct 2024 18:40:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t1VQX-008T3K-VG for pgsql-admin@arkaria.postgresql.org; Thu, 17 Oct 2024 18:40:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1VQX-008T3B-E7 for pgsql-admin@lists.postgresql.org; Thu, 17 Oct 2024 18:40:49 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t1VQU-001PVF-SF for pgsql-admin@lists.postgresql.org; Thu, 17 Oct 2024 18:40:48 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-a9a0c40849cso188168166b.3 for ; Thu, 17 Oct 2024 11:40:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729190445; x=1729795245; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=XZP/DygcZn2qz+3hkOFJvQ+1vGWcwDVo2qz33sBk++s=; b=RbL9Rj8E2DNWr1JpADqbyLQShqeAMw/g4QteTR343pk3JRPk9PcwuDaupcBSMD4juK SqumuXkBLCb4B33DtsjJdMevYcIka3JWJ8FeKCxrVcYvO8HoHZf3YmIjleGnAJ5w/9HR a0j9262jhmpACUq/1xs+SyLMF3Mek+tMPgacELPA4LYl/V/jNgw/XlRag91kqRbFNPO+ GASv5HYKPA/ty94qE/Z94/Xu+/f6RDOxqOnufBww8SNJY98HsCSvcBiO32TwxZboexL2 9xQ0DEDOP8Lrq8/SaBrqdMTXyg/xPndySBux9iEU8PTFB3hjsWFFJ+MRJym/zII55p6Z IIbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729190445; x=1729795245; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=XZP/DygcZn2qz+3hkOFJvQ+1vGWcwDVo2qz33sBk++s=; b=ZE3N/gHom5WLyDmE6coVEiuXO0sY2GGe6bfkaw8jgwDtPTBe+7+AKWNFqlMGHmXnIy gPCo3Fo90DnH0TXSmktpHJdKGYxrhbkHh+ITXkKC6hnYk9Xq1xwj3GOdIeqVWvcg4gzV LizxLtO3OQWraoOsmA1r1B3YgfROv5WuaewILUNoIBIRen4dnL57g+jcT/j+EezN/QHs IqCGQkY04lO3UjYpY097IDYJGkleLZZi1aotQ+1cS5FWbRZueTPkKC1LuTz9B8bpDqCY LY32GbTFp655gPeWHfAfcNO+8HcWBlZ/AVxpqumQLXgFR2ihfDgk1ipXndYfUOpC1v3Z mweQ== X-Gm-Message-State: AOJu0Ywh4E/StI/2WTKudNrxG+ekgFiV8y9lhHDxS58cn35T9VqIM3Wi 1yiKJsfumUSIKGOXZyU5AHQAePZbYWcDrv7/aoqUw/M5yOTL6G4UOftMnzxs7EHuYwIh83eeoTm FCGqVdbp76dcQJxeuYmAaB7uqXJ6o4A== X-Google-Smtp-Source: AGHT+IFSeyntbqHYtrkKMa1ko9+FiSSjTCebLc8uLvSFYfdWD3/sT4WGX3/S9kbBZt+W9bpHzwdAXYTddwBU8v9J9Es= X-Received: by 2002:a17:906:f59b:b0:a9a:238a:381d with SMTP id a640c23a62f3a-a9a238a40demr996472566b.52.1729190445135; Thu, 17 Oct 2024 11:40:45 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: rams nalabolu Date: Thu, 17 Oct 2024 13:40:34 -0500 Message-ID: Subject: Re: 101 Grants and Access Right Table/View To: "Wong, Kam Fook (TR Technology)" Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000003b41fe0624b08656" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003b41fe0624b08656 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Who is the grantor? And the objects owner? Only the objects owner can grant the privileges On Thu, Oct 17, 2024 at 1:38=E2=80=AFPM Wong, Kam Fook (TR Technology) < kamfook.wong@thomsonreuters.com> wrote: > I have a simple question for =E2=80=9Caccess rights=E2=80=9D view or tabl= e within > Postgres. > > Here is my grant query: > > GRANT USAGE ON SCHEMA abc TO abc_user; > > GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA abc TO > abc_user; > > GRANT ALL ON ALL SEQUENCES IN SCHEMA abc TO abc_user; > > GRANT EXECUTE ON ALL ROUTINES IN SCHEMA abc TO abc_user; > > But I can=E2=80=99t find a view/table that is associated with the above g= rants? > The view/table below doesn=E2=80=99t shown the above granted rights. > > > > select * from information_schema.role_table_grants; > > select * from information_schema.usage_privileges > > > Thank you > > Kam Fook Wong > This e-mail is for the sole use of the intended recipient and contains > information that may be privileged and/or confidential. If you are not an > intended recipient, please notify the sender by return e-mail and delete > this e-mail and any attachments. Certain required legal entity disclosure= s > can be accessed on our website: > https://www.thomsonreuters.com/en/resources/disclosures.html > --0000000000003b41fe0624b08656 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Who is the grantor? And the objects owner?
Only the objects owner can grant the privileges=C2=A0
<= br>
On Thu,= Oct 17, 2024 at 1:38=E2=80=AFPM Wong, Kam Fook (TR Technology) <kamfook.wong@thomsonreuters.com= > wrote:

I have a simple qu= estion for =E2=80=9Caccess rights=E2=80=9D view or table within Postgres.= =C2=A0

Here is my grant q= uery:

GRANT USAGE ON SCH= EMA abc TO abc_user;

GRANT SELECT, INSE= RT, UPDATE, DELETE ON ALL TABLES IN SCHEMA abc TO abc_user;

GRANT ALL ON ALL S= EQUENCES IN SCHEMA abc TO abc_user;

GRANT EXECUTE ON A= LL ROUTINES IN SCHEMA abc TO abc_user;

But I can=E2=80=99t find a view/table that is associated with the above gra= nts?=C2=A0 The view/table below doesn=E2=80=99t shown the above granted rig= hts.

=C2=A0

select * from info= rmation_schema.role_table_grants;

select * from info= rmation_schema.usage_privileges


Thank you

Kam Fook Wong

This e-mail is for the sole use of the intended recipient and contains info= rmation that may be privileged and/or confidential. If you are not an inten= ded recipient, please notify the sender by return e-mail and delete this e-= mail and any attachments. Certain required legal entity disclosures can be accessed on our website: https://www.thomsonreuters.com/en/resources/disclosures.html
--0000000000003b41fe0624b08656--