From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ahmed Ibrahim <ahmedhssn02@gmail.com>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Check used privilege in a statment
In-reply-to: <CAKfRk1uCwdmMckxQ_W0aU0e8Uq5ZgMM86jsHcQTidatrJmZXfw@mail.gmail.com>
References: <CAKfRk1uCwdmMckxQ_W0aU0e8Uq5ZgMM86jsHcQTidatrJmZXfw@mail.gmail.com>
Comments: In-reply-to Ahmed Ibrahim <ahmedhssn02@gmail.com>
	message dated "Mon, 09 Sep 2024 21:22:25 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3362836.1725948498.1@sss.pgh.pa.us>
Date: Tue, 10 Sep 2024 02:08:18 -0400
Message-ID: <3362837.1725948498@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3362837.1725948498%40sss.pgh.pa.us>
Precedence: bulk

Ahmed Ibrahim <ahmedhssn02@gmail.com> writes:
> I am trying to know which privileges are used in a specific query but I am
> facing problems when I have nested queries. Where is the best place/hook I
> can check for all needed permissions for a query in the source? Currently,
> trying it in the exectuter start but the nested queries are problematic.

Nested queries are irrelevant, because the query is flat (or at least
the rangetable is) by the time it gets to the executor.  See
ExecCheckPermissions.

			regards, tom lane