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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1t1XsI-00Glws-Ah
	for pgsql-admin@arkaria.postgresql.org; Thu, 17 Oct 2024 21:17:38 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1t1XsG-00AJoz-Mp
	for pgsql-admin@arkaria.postgresql.org; Thu, 17 Oct 2024 21:17:37 +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 <tgl@sss.pgh.pa.us>)
	id 1t1XsG-00AJoA-Br
	for pgsql-admin@lists.postgresql.org; Thu, 17 Oct 2024 21:17:36 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1t1XsA-001Qbb-CP
	for pgsql-admin@lists.postgresql.org; Thu, 17 Oct 2024 21:17:35 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 49HLHTSd717066;
	Thu, 17 Oct 2024 17:17:29 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>
cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: [EXT] Re: 101 Grants and Access Right Table/View
In-reply-to: 
 <CH0PR03MB610027C698325AB59F9A9C21FE472@CH0PR03MB6100.namprd03.prod.outlook.com>
References: 
 <CH0PR03MB6100645C5E5EF4CBD89AB31BFE472@CH0PR03MB6100.namprd03.prod.outlook.com>
 <704895.1729194519@sss.pgh.pa.us>
 <CH0PR03MB610027C698325AB59F9A9C21FE472@CH0PR03MB6100.namprd03.prod.outlook.com>
Comments: In-reply-to "Wong,
 Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>
	message dated "Thu, 17 Oct 2024 21:09:01 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <717064.1729199849.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 17 Oct 2024 17:17:29 -0400
Message-ID: <717065.1729199849@sss.pgh.pa.us>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/717065.1729199849%40sss.pgh.pa.us>
Precedence: bulk

"Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com> writes:
> These are existing objects/tables.  So I assume after the grants were ru=
n,  the  information_schema.role_table_grants and information_schema.usage=
_privileges shouldn't be blank right/now rows return?

Maybe.  I believe both of those views will only show information about
grants where you (the user reading the view) are grantor or grantee.
You've not provided any details about your test setup ...

			regards, tom lane