Added support for permissive/restricted policy type while creating RLS Policy. Fixes #5622
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=36a2c073bd88c8ad55900daf390d1ef76af98cca Author: Pradip Parkale <pradip.park...@enterprisedb.com> Modified Files -------------- docs/en_US/images/rls_policy_commands_tab.png | Bin 73862 -> 297445 bytes docs/en_US/images/rls_policy_general_tab.png | Bin 70609 -> 84836 bytes docs/en_US/images/rls_policy_sql_tab.png | Bin 120105 -> 102186 bytes docs/en_US/release_notes_4_24.rst | 1 + docs/en_US/rls_policy_dialog.rst | 3 +- .../tables/row_security_policies/__init__.py | 43 ++++----- .../static/js/row_security_policy.js | 25 ++++- .../tests/10_plus/alter_policy.sql | 9 ++ .../tests/10_plus/alter_policy_msql.sql | 2 + .../tests/10_plus/create_all_event_policy.sql | 11 +++ .../tests/10_plus/create_insert_policy.sql | 9 ++ .../tests/10_plus/create_public_policy.sql | 9 ++ .../tests/10_plus/create_select_policy.sql | 9 ++ .../row_security_policies/tests/10_plus/test.json | 105 +++++++++++++++++++++ .../row_security_policies/tests/default/test.json | 3 +- .../schemas/tables/row_security_policies/utils.py | 41 ++++---- .../row_security_policies/sql/10_plus/create.sql | 27 ++++++ .../sql/10_plus/properties.sql | 22 +++++ .../row_security_policies/sql/default/create.sql | 24 +++++ .../row_security_policies/sql/default/delete.sql | 1 + .../sql/default/get_parent.sql | 5 + .../sql/default/get_policy_name.sql | 9 ++ .../sql/default/get_position.sql | 2 + .../row_security_policies/sql/default/nodes.sql | 13 +++ .../sql/default/properties.sql | 21 +++++ .../row_security_policies/sql/default/update.sql | 33 +++++++ 26 files changed, 381 insertions(+), 46 deletions(-)