syncope-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ilgro...@apache.org
Subject [01/10] syncope git commit: Missing views for PostgreSQL
Date Fri, 06 Jul 2018 13:32:03 GMT
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ò <ilgrosso@apache.org>
Authored: Fri Jul 6 14:23:01 2018 +0200
Committer: Francesco Chicchiriccò <ilgrosso@apache.org>
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
 


Mime
View raw message