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 <pgadmin-support-owner+archive@lists.postgresql.org>)
	id 1sniSc-005Zkz-V2
	for pgadmin-support@arkaria.postgresql.org; Mon, 09 Sep 2024 17:45:59 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgadmin-support-owner+archive@lists.postgresql.org>)
	id 1sniSc-00GBbC-H2
	for pgadmin-support@arkaria.postgresql.org; Mon, 09 Sep 2024 17:45:58 +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 1sniSc-00GBaP-8Q
	for pgadmin-support@lists.postgresql.org; Mon, 09 Sep 2024 17:45:58 +0000
Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e])
	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 1sniSY-000L49-Nv
	for pgadmin-support@postgresql.org; Mon, 09 Sep 2024 17:45:57 +0000
Received: by mail-ej1-x62e.google.com with SMTP id
 a640c23a62f3a-a7a843bef98so247312766b.2
        for <pgadmin-support@postgresql.org>;
 Mon, 09 Sep 2024 10:45:55 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1725903955; x=1726508755;
 darn=postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=HkiC1yWpu4VNsZTCK8FMECf9zsmS5iUz4LZkjHAQEBI=;
        b=jvCcZZ/pNHpYSlWHRZGlNwYXpqRbjWX61hP0Sf5Gm3c4YwwDtoNZ6laIRwDRNJ9kyL
         iHweyqNVY2iAnlLpoqpew/4w2SZJbIoTLE9TjhmUxvUO9hY6gqVN4p6xXq+IGcZ5B1WQ
         GgSs57pbjaYUuXo9s78ePVHc/z5105okGSK558zO+9PD94LdWc8WEZGDKsiU1Z+8AGNe
         FQSh4rcVWi550/qjCmSNpO+KJ0dP1iA5ur0EZANoFX2+7cUxbpnT1jf3FwqU9Jr+lzuV
         7W4Wqouh0K1Lxbz/cJ+zAwWzysHaRL975vn6XxxJm4BjVEcZc6Ph84Vj/5GeVg8/dCEf
         E3rA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1725903955; x=1726508755;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=HkiC1yWpu4VNsZTCK8FMECf9zsmS5iUz4LZkjHAQEBI=;
        b=icFzJCCaYrCr7xUdvfObsw4NHT7s5F8LD4fH6PV+1KoBieqwXPRPU6XY1ul0cehi77
         eA8InWn+dPpY97h/TerastdkQlxS1BYOAde9mdSMstXbqn52pboPe/WEGDC9Bpol0pHe
         i7HMPbAc/S4mB4SJLodM4WdGeEoPFlo72+cPeUK/hNPLefF3AF7v5189T9K8VoAsin3S
         8rZ5WtoDgChGbBn/2l/l62DVN1rFe0qxtZ7XRzOE+xLt6JYMUEMCLSboVYuK+P+4fa3q
         NqsLumlltzB6+2Ub64Gbfvk+l+WjYj6DnCTPsfqCZV1SYFCq4g0LWB88bJ1krROmdqFD
         cBIQ==
X-Gm-Message-State: AOJu0YwJzVEmh6P3W/ggXYU4oLgCGcRH+9wIqXZDaMa/m4RVqqwcbmYH
	aPXVkI7c53ehF2kz0St1fotzRC4MTdZlHrIG1KWFE8Uar1rn1qnReJM2ZNRbQcamKqiuYT2CyIZ
	64AR9mrtgOberJvYc3imWJ7rSapE9PaQx
X-Google-Smtp-Source: 
 AGHT+IEg+RMtoW5QscyFRdK0jYEbjq0icoSaH1XJer5YK0NxBENaPWARAgJGLZIPT28JZk3KgwCAuiBRHOy/QzuD4yQ=
X-Received: by 2002:a17:907:1c23:b0:a8d:2e3a:5303 with SMTP id
 a640c23a62f3a-a8d2e3a54c6mr547155066b.39.1725903954372; Mon, 09 Sep 2024
 10:45:54 -0700 (PDT)
MIME-Version: 1.0
From: Ahmed Ibrahim <ahmedhssn02@gmail.com>
Date: Mon, 9 Sep 2024 10:45:42 -0700
Message-ID: 
 <CAKfRk1utHy+jmaQ7ivOJahx-Jt_4miRXZGQWEqvPQ2E+aEfY4Q@mail.gmail.com>
Subject: Check used privilege in a statment
To: pgadmin-support@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001df3260621b354f4"
List-Id: <pgadmin-support.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgadmin-support@lists.postgresql.org>
List-Owner: <mailto:pgadmin-support-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgadmin-support>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKfRk1utHy%2BjmaQ7ivOJahx-Jt_4miRXZGQWEqvPQ2E%2BaEfY4Q%40mail.gmail.com>
Precedence: bulk

--0000000000001df3260621b354f4
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!
Ahmed

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

<div dir=3D"ltr"><div>Hi,</div>I am trying to know which privileges are use=
d 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 q=
uery in the source? Currently, trying it in the exectuter=C2=A0start but th=
e nested queries are problematic.=C2=A0<div>Thanks!</div><div>Ahmed</div></=
div>

--0000000000001df3260621b354f4--