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-general-owner+archive@lists.postgresql.org>)
	id 1snsOo-006ehy-Lk
	for pgsql-general@arkaria.postgresql.org; Tue, 10 Sep 2024 04:22:43 +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-general-owner+archive@lists.postgresql.org>)
	id 1snsOo-00655w-8R
	for pgsql-general@arkaria.postgresql.org; Tue, 10 Sep 2024 04:22:42 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ahmedhssn02@gmail.com>)
	id 1snsOn-00655e-Th
	for pgsql-general@lists.postgresql.org; Tue, 10 Sep 2024 04:22:41 +0000
Received: from mail-ej1-x633.google.com ([2a00:1450:4864:20::633])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ahmedhssn02@gmail.com>)
	id 1snsOj-000PfC-AX
	for pgsql-general@lists.postgresql.org; Tue, 10 Sep 2024 04:22:40 +0000
Received: by mail-ej1-x633.google.com with SMTP id a640c23a62f3a-a8d60e23b33so204627566b.0
        for <pgsql-general@lists.postgresql.org>; Mon, 09 Sep 2024 21:22:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1725942157; x=1726546957; darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=raQQdgdRh7Tb8qzzmaFSwG//FF1jpLscvGJManKNQZs=;
        b=LZInPTAAH77teDl9hQwR/rgAX0pRfvhRMmib8q1T5LRzqxHMZsJ++A5m6afKUMDOij
         ekT4UOCAONKNkFTCVXLYLH4d/BjAqwu1JQ6BH1KFBeK9swAIRzVsatc9oX4mPIBQRdP4
         TyubO6P9GhwNRhuT8iYkmjrgViMZlDDpY/6/0dJHH6sV6fEugepwZb6CsR5M/nHbsXwE
         2L8/F7PExLGQeIxpGalo6mmfP7CWc1hEPTgOiG/QdIS51jL6h5sEsLHBp4LfaXlfB/Dx
         AaHZ8lkf4961Pjl16BQQqvHPDNsUaymbskPVnXoMRsljgOtFKsRQP0UlTUPZTkRVe2D2
         PMaw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1725942157; x=1726546957;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=raQQdgdRh7Tb8qzzmaFSwG//FF1jpLscvGJManKNQZs=;
        b=vnupVjm2P8n/62uhlo0C3biCf9R7YgYB4wL/7tMEM+Q7DoaAd2xarc0d0CpXXKKxIL
         UV15McZUVvnixRqXgMX6QJ5ou75efZ0pna50gVIsDaXyxW+ZMkuIvYv/MAu4E6x8vKZL
         Ai6rRYqWZJitlaQOWd+xmpGID2oI6/U1TtkZwnmimggKFZ058Fuo/qOEgjjliyxnZVh0
         STijCKkjwr74UO7/Psd0QeDhpSoYGvRBAOlCD56GKqrDC61W4ZMdVGZQZKApNlfGZvXa
         36zMV7E/uCTNaGMg/Sm4q3M+ZDS9/K9vd+sw8gnvoo3muF+HxSzufJHIGEyVTdDOVO2g
         GuxA==
X-Gm-Message-State: AOJu0YxXn2/V7NdgGlWiT9I1FKykQNJxxLxY1iBYl2Nol0SCBIPtfi7v
	bLrv+PaY6d/65aWYXUPS2gDZ8iEAK5h3wdChj96Y4eECpBr+D5nJKJeH/Xtp/6BAvxpBN2wpOlq
	G9PRUaFsl63htl6LcLxyvaSaXMqTfajSB
X-Google-Smtp-Source: AGHT+IF0VrI87cNUy8jrWGDpmmKZBN4M5mxcQYKnVXVfsL0fKVpLCggO7Tq40sMdkUU8Prvf/p4Erhp62OE7IunsVlQ=
X-Received: by 2002:a17:907:7f14:b0:a8d:4243:2365 with SMTP id
 a640c23a62f3a-a8d42433fd0mr811071566b.41.1725942156688; Mon, 09 Sep 2024
 21:22:36 -0700 (PDT)
MIME-Version: 1.0
From: Ahmed Ibrahim <ahmedhssn02@gmail.com>
Date: Mon, 9 Sep 2024 21:22:25 -0700
Message-ID: <CAKfRk1uCwdmMckxQ_W0aU0e8Uq5ZgMM86jsHcQTidatrJmZXfw@mail.gmail.com>
Subject: Check used privilege in a statment
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002704210621bc3933"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAKfRk1uCwdmMckxQ_W0aU0e8Uq5ZgMM86jsHcQTidatrJmZXfw%40mail.gmail.com>
Precedence: bulk

--0000000000002704210621bc3933
Content-Type: text/plain; charset="UTF-8"

Hi,
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.
Thanks!

--0000000000002704210621bc3933
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div><div><div style=3D"font-family:-apple-system,&quot;helvetica neue&quot=
;;font-size:1rem;font-style:normal;font-weight:400;letter-spacing:normal;te=
xt-indent:0px;text-transform:none;white-space:normal;word-spacing:1px;text-=
decoration:none;background-color:rgba(0,0,0,0);border-color:rgb(49,49,49);c=
olor:rgb(49,49,49)">Hi,</div><span style=3D"font-family:-apple-system,&quot=
;helvetica neue&quot;;font-size:16px;font-style:normal;font-weight:400;lett=
er-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;wo=
rd-spacing:1px;text-decoration:none;float:none;display:inline!important;bac=
kground-color:rgba(0,0,0,0);border-color:rgb(49,49,49);color:rgb(49,49,49)"=
>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=C2=A0start but the nested queries are problemat=
ic.=C2=A0</span><div style=3D"font-family:-apple-system,&quot;helvetica neu=
e&quot;;font-size:1rem;font-style:normal;font-weight:400;letter-spacing:nor=
mal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:1px=
;text-decoration:none;background-color:rgba(0,0,0,0);border-color:rgb(49,49=
,49);color:rgb(49,49,49)">Thanks!</div></div>
</div>

--0000000000002704210621bc3933--