Postgres Pro
Downloads
Home   >   mailing lists

Thread: Check used privilege in a statment

Check used privilege in a statment

From
Ahmed Ibrahim
Date:
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

Re: Check used privilege in a statment

From
Yogesh Mahajan
Date:
Hi,

Can you please share what the issue is with pgadmin? If query is related to postgresql, then mailing list is pgsql-general@lists.postgresql.org

Thanks,
Yogesh Mahajan
EnterpriseDB


On Mon, Sep 9, 2024 at 11:16 PM Ahmed Ibrahim <ahmedhssn02@gmail.com> wrote:
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