babelfish-for-postgresql / babelfish_extensions / 17784314195

77%

push

github

Fix column-level permissions loss during ALTER VIEW operations (#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%)

50800 of 66509 relevant lines covered (76.38%)

382924.16 hits per line