pgsql: Make inherited TRUNCATE perform access permission checks on pare
pgsql: Make inherited TRUNCATE perform access permission checks on pare
От:
Fujii Masao <fujii@postgresql.org>
Дата:
Make inherited TRUNCATE perform access permission checks on parent table only. Previously, TRUNCATE command through a parent table checked the permissions on not only the parent table but also the children tables inherited from it. This was a bug and inherited queries should perform access permission checks on the parent table only. This commit fixes that bug. Back-patch to all supported branches. Author: Amit Langote Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAHGQGwFHdSvifhJE+-GSNqUHSfbiKxaeQQ7HGcYz6SC2n_oDcg@mail.gmail.com Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/de0177788bf3f0531af32cd5143a73e1234862d3 Modified Files -------------- src/backend/commands/tablecmds.c | 32 +++++++++++++++++++++++++------- src/test/regress/expected/privileges.out | 21 +++++++++++++++++++++ src/test/regress/sql/privileges.sql | 14 ++++++++++++++ 3 files changed, 60 insertions(+), 7 deletions(-)