MIME-Version: 1.0
From: Edwin UY <edwin.uy@gmail.com>
Date: Mon, 16 Feb 2026 10:19:22 +1300
Message-ID: 
 <CA+wokJ9CPLZYPzTC8tHTDab4nUnERYcqk3W+EsbdOhTc4pNL0A@mail.gmail.com>
Subject: has_table_privilege
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a76c03064ae366a8"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ9CPLZYPzTC8tHTDab4nUnERYcqk3W%2BEsbdOhTc4pNL0A%40mail.gmail.com>
Precedence: bulk

--000000000000a76c03064ae366a8
Content-Type: text/plain; charset="UTF-8"

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?

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

<div dir=3D"ltr">
<p><span style=3D"font-family:monospace">Is there no shortcut alternative t=
o using
select has_table_privilegeso it will just check all possible privileges?</s=
pan></p><p><span style=3D"font-family:monospace">select has_table_privilege=
(&#39;user_or_role&#39;,&#39;table_name&#39;,&#39;update&#39;);<br>select h=
as_table_privilege(&#39;user_or_role&#39;,&#39;table_name&#39;,&#39;select,=
insert&#39;);=C2=A0</span></p><p><span style=3D"font-family:monospace">I th=
ought when running=C2=A0
select has_table_privilege(&#39;user_or_role&#39;,&#39;table_name&#39;,&#39=
;select,insert,update,delete&#39;); it will enumerate the privilege. Isn=
9;t it not supposed to?</span></p><p><span style=3D"font-family:monospace">=
<br></span></p><p><span style=3D"font-family:monospace"><br></span></p>

<span style=3D"font-family:monospace"><br></span></div>

--000000000000a76c03064ae366a8--