| 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(-)
| 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() |