Horton

Remove old RULE privilege completely.

Fujii Masao <fujii@postgresql.org>

View on postgr.es
Commit: fefa76f70fdc75c91f80bddce2df7a8825205962
Author: Fujii Masao <fujii@postgresql.org>
Date: 2024-09-12T10:33:44Z
Releases: 18.0 
Remove old RULE privilege completely.

The RULE privilege for tables was removed in v8.2, but for backward
compatibility, GRANT/REVOKE and privilege functions like
has_table_privilege continued to accept the RULE keyword without
any effect.

After discussions on pgsql-hackers, it was agreed that this compatibility
is no longer needed. Since it's been long enough since the deprecation,
we've decided to fully remove support for RULE privilege,
so GRANT/REVOKE and privilege functions will no longer accept it.

Author: Fujii Masao
Reviewed-by: Nathan Bossart
Discussion: https://postgr.es/m/976a3581-6939-457f-b947-fc3dc836c083@oss.nttdata.com

Files

PathChange+/−
src/backend/catalog/aclchk.c modified +0 −2
src/backend/utils/adt/acl.c modified +0 −6
src/test/regress/expected/privileges.out modified +0 −9
src/test/regress/sql/privileges.sql modified +0 −4

Discussion