Repository: syncope Updated Branches: refs/heads/2_0_X 703fe4d45 -> 81b3a8323 refs/heads/master 9455410cc -> fab232684
Missing views for PostgreSQL Project: http://git-wip-us.apache.org/repos/asf/syncope/repo Commit: http://git-wip-us.apache.org/repos/asf/syncope/commit/d852fca2 Tree: http://git-wip-us.apache.org/repos/asf/syncope/tree/d852fca2 Diff: http://git-wip-us.apache.org/repos/asf/syncope/diff/d852fca2 Branch: refs/heads/master Commit: d852fca2573b08808e65790b5c3da0e462856cc3 Parents: 9455410 Author: Francesco Chicchiriccò <[email protected]> Authored: Fri Jul 6 14:23:01 2018 +0200 Committer: Francesco Chicchiriccò <[email protected]> Committed: Fri Jul 6 14:23:01 2018 +0200 ---------------------------------------------------------------------- .../src/main/resources/postgres/views.xml | 14 ++++++++++++++ 1 file changed, 14 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/syncope/blob/d852fca2/fit/core-reference/src/main/resources/postgres/views.xml ---------------------------------------------------------------------- diff --git a/fit/core-reference/src/main/resources/postgres/views.xml b/fit/core-reference/src/main/resources/postgres/views.xml index 1427872..b6664c0 100644 --- a/fit/core-reference/src/main/resources/postgres/views.xml +++ b/fit/core-reference/src/main/resources/postgres/views.xml @@ -111,6 +111,20 @@ under the License. SELECT ss.user_id AS any_id, ss.role_id AS role_id FROM SyncopeUser_SyncopeRole ss </entry> + <entry key="user_search_priv"> + CREATE VIEW user_search_priv AS + + SELECT ss.user_id AS any_id, sp.privilege_id AS privilege_id + FROM SyncopeUser_SyncopeRole ss, SyncopeRole_Privilege sp + WHERE ss.role_id = sp.role_id + </entry> + <entry key="user_search_dynpriv"> + CREATE VIEW user_search_dynpriv AS + + SELECT any_id, privilege_id + FROM DynRoleMembers drm, SyncopeRole_Privilege rp + WHERE drm.role_id = rp.role_id + </entry> <entry key="user_search_resource"> CREATE VIEW user_search_resource AS
