public inbox for [email protected]  

help / color / mirror / Atom feed

From: Edwin UY <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: has_table_privilege
Date: Mon, 16 Feb 2026 10:19:22 +1300
Message-ID: <CA+wokJ9CPLZYPzTC8tHTDab4nUnERYcqk3W+EsbdOhTc4pNL0A@mail.gmail.com> (raw)

Is there no shortcut alternative to using select has_table_privilegeso it
will just check all possible privileges?

select has_table_privilege('user_or_role','table_name','update');
select has_table_privilege('user_or_role','table_name','select,insert');

I thought when running  select
has_table_privilege('user_or_role','table_name','select,insert,update,delete');
it will enumerate the privilege. Isn't it not supposed to?

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: has_table_privilege
  In-Reply-To: <CA+wokJ9CPLZYPzTC8tHTDab4nUnERYcqk3W+EsbdOhTc4pNL0A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox