Added support of Row Security Policies. Fixes #5516 Branch ------ master
Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=18277543b6c702fa84f332c3a74840c376cd43e2 Author: Pradip Parkale <pradip.park...@enterprisedb.com> Modified Files -------------- docs/en_US/release_notes_4_23.rst | 1 + .../servers/databases/schemas/tables/__init__.py | 11 + .../tables/row_security_policies/__init__.py | 589 +++++++++++++++++++++ .../static/img/coll-row_security_policy.svg | 37 ++ .../static/img/row_security_policy.svg | 22 + .../static/js/row_security_policy.js | 184 +++++++ .../tables/row_security_policies/tests/__init__.py | 16 + .../tests/default/alter_policy.sql | 11 + .../tests/default/alter_policy_msql.sql | 2 + .../tests/default/create_insert_policy.sql | 11 + .../tests/default/create_public_policy.sql | 11 + .../tests/default/create_select_policy.sql | 11 + .../row_security_policies/tests/default/test.json | 86 +++ .../row_security_policies/tests/rls_test_data.json | 493 +++++++++++++++++ .../row_security_policies/tests/test_rls_add.py | 116 ++++ .../row_security_policies/tests/test_rls_delete.py | 91 ++++ .../tests/test_rls_delete_multiple.py | 94 ++++ .../row_security_policies/tests/test_rls_get.py | 98 ++++ .../row_security_policies/tests/test_rls_put.py | 122 +++++ .../tables/row_security_policies/tests/utils.py | 140 +++++ .../schemas/tables/row_security_policies/utils.py | 145 +++++ .../databases/schemas/tables/static/js/table.js | 61 ++- .../row_security_policies/sql/9.5_plus/create.sql | 22 + .../row_security_policies/sql/9.5_plus/delete.sql | 1 + .../sql/9.5_plus/get_parent.sql | 5 + .../sql/9.5_plus/get_policy_name.sql | 9 + .../sql/9.5_plus/get_position.sql | 2 + .../row_security_policies/sql/9.5_plus/nodes.sql | 13 + .../sql/9.5_plus/properties.sql | 19 + .../row_security_policies/sql/9.5_plus/update.sql | 33 ++ .../tables/templates/tables/sql/10_plus/create.sql | 17 + .../templates/tables/sql/10_plus/properties.sql | 2 +- .../tables/templates/tables/sql/11_plus/create.sql | 17 + .../templates/tables/sql/11_plus/properties.sql | 2 +- .../tables/templates/tables/sql/11_plus/update.sql | 24 + .../tables/templates/tables/sql/12_plus/create.sql | 17 + .../templates/tables/sql/12_plus/properties.sql | 2 +- .../tables/templates/tables/sql/12_plus/update.sql | 25 + .../templates/tables/sql/9.6_plus/create.sql | 18 + .../templates/tables/sql/9.6_plus/properties.sql | 2 +- .../templates/tables/sql/9.6_plus/update.sql | 25 + .../tables/templates/tables/sql/default/create.sql | 15 + .../templates/tables/sql/default/properties.sql | 2 +- .../tables/templates/tables/sql/default/update.sql | 24 + .../servers/databases/schemas/tables/utils.py | 34 ++ web/webpack.config.js | 1 + web/webpack.shim.js | 1 + 47 files changed, 2678 insertions(+), 6 deletions(-)
