babelfish-for-postgresql / babelfish_extensions / 17811032818

76%

BABEL_5_X_DEV: 77%

push

github

Fix column-level permissions loss during ALTER VIEW operations (#4096)

Cherry-Picked from BABEL_5_X_DEV
PR link: #4036

Description
This PR fixes an issue where column-level permissions were being lost when a view was modified using ALTER VIEW. While view-level ACLs were correctly preserved, column-level ACLs stored in pg_attribute.attacl were not being carried over to the new view definition.

Changes:
Added a ColumnAclInfo structure to store column permission information
get_old_view_column_acls() to retrieve column-level ACLs before view alteration
restore_view_column_acls() to restore column-level ACLs after view recreation

Issues Resolved: BABEL-5936
Signed off: Rahul Parande rparande@amazon.com

48 of 50 new or added lines in 1 file covered. (96.0%)

49933 of 65697 relevant lines covered (76.0%)

382327.22 hits per line