pgsql: Prohibit GRANT ... ON TABLE on a property graph

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Prohibit GRANT ... ON TABLE on a property graph
Date: 2026-08-04 08:16:53
Message-ID: E1wrAKT-000000008cy-20f1@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Prohibit GRANT ... ON TABLE on a property graph

We allowed GRANT ... ON TABLE on sequences for backward compatibility.
We don't need to consider backward compatibility in case of property
graphs since we will be prohibiting its usage on property graph from
the very release which introduced property graphs.

Change regression tests that used GRANT ... ON [TABLE] on property
graphs to use GRANT ... ON PROPERTY GRAPH instead.

While here, add the missing RELKIND_PROPGRAPH cases in
pg_class_aclmask_ext() and in the object-type switch in
ExecGrant_Relation() so that the default ACL and the objtype passed to
restrict_and_check_grant() are correct.

Author: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Reviewed-by: Noah Misch <noah(at)leadboat(dot)com>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://www.postgresql.org/message-id/20260630023308.c7.noahmisch@microsoft.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/fa62d4f6ea7529aa75105aa1ed3b43477ab365a0

Modified Files
--------------
src/backend/catalog/aclchk.c | 20 +++++++++++++++++++-
src/test/regress/expected/create_property_graph.out | 3 +++
src/test/regress/expected/graph_table_rls.out | 6 +++---
src/test/regress/expected/privileges.out | 4 ++--
src/test/regress/sql/create_property_graph.sql | 1 +
src/test/regress/sql/graph_table_rls.sql | 6 +++---
src/test/regress/sql/privileges.sql | 4 ++--
7 files changed, 33 insertions(+), 11 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2026-08-04 08:37:45 pgsql: doc: Add PROPERTY GRAPH to the access privilege tables
Previous Message Fujii Masao 2026-08-04 08:10:11 pgsql: Fix error handling in getCopyDataMessage() and pqFunctionCall3()