Update sql for adding permissins from Ben Ostrowsky and based on http://open-ils...

diff --git a/1.6/admin/sip.xml b/1.6/admin/sip.xml
index 7f670c9..b22021b 100644 (file)
--- a/1.6/admin/sip.xml
+++ b/1.6/admin/sip.xml
@@ -98,11 +98,29 @@ max_servers='25'
                                        <para>OR use SQL like:</para>\r
 <screen>\r
 <userinput>\r
-INSERT INTO permission.grp_tree (id,name,parent,description,application_perm)\r
+INSERT INTO permission.grp_tree (id,name,parent,description,application_perm) \r
 VALUES (8, 'SIP', 1, 'SIP2 Client Systems', 'group_application.user.sip_client');\r
-\r
-INSERT INTO permission.grp_perm_map (grp,perm,depth) \r
-VALUES (8,15,0),(8,16,0),(8,17,0),(8,31,0),(8,32,0),(8,48,0),(8,54,0),(8,75,0),(8,82,0);\r
+ \r
+INSERT INTO\r
+  permission.grp_perm_map (grp, perm, depth, grantable)\r
+SELECT\r
+  g.id, p.id, 0, FALSE\r
+FROM\r
+  permission.grp_tree g,\r
+  permission.perm_list p\r
+WHERE\r
+  g.name = 'SIP' AND\r
+  p.code IN (\r
+    'COPY_CHECKIN',\r
+    'COPY_CHECKOUT',\r
+    'RENEW_CIRC',\r
+    'VIEW_CIRCULATIONS',\r
+    'VIEW_COPY_CHECKOUT_HISTORY',\r
+    'VIEW_PERMIT_CHECKOUT',\r
+    'VIEW_USER',\r
+    'VIEW_USER_FINES_SUMMARY',\r
+    'VIEW_USER_TRANSACTIONS'\r
+);\r
 </userinput>\r
 </screen>\r
                                        \r

diff --git a/2.0/admin/sip.xml b/2.0/admin/sip.xml
index 7f670c9..b22021b 100644 (file)
--- a/2.0/admin/sip.xml
+++ b/2.0/admin/sip.xml
@@ -98,11 +98,29 @@ max_servers='25'
                                        <para>OR use SQL like:</para>\r
 <screen>\r
 <userinput>\r
-INSERT INTO permission.grp_tree (id,name,parent,description,application_perm)\r
+INSERT INTO permission.grp_tree (id,name,parent,description,application_perm) \r
 VALUES (8, 'SIP', 1, 'SIP2 Client Systems', 'group_application.user.sip_client');\r
-\r
-INSERT INTO permission.grp_perm_map (grp,perm,depth) \r
-VALUES (8,15,0),(8,16,0),(8,17,0),(8,31,0),(8,32,0),(8,48,0),(8,54,0),(8,75,0),(8,82,0);\r
+ \r
+INSERT INTO\r
+  permission.grp_perm_map (grp, perm, depth, grantable)\r
+SELECT\r
+  g.id, p.id, 0, FALSE\r
+FROM\r
+  permission.grp_tree g,\r
+  permission.perm_list p\r
+WHERE\r
+  g.name = 'SIP' AND\r
+  p.code IN (\r
+    'COPY_CHECKIN',\r
+    'COPY_CHECKOUT',\r
+    'RENEW_CIRC',\r
+    'VIEW_CIRCULATIONS',\r
+    'VIEW_COPY_CHECKOUT_HISTORY',\r
+    'VIEW_PERMIT_CHECKOUT',\r
+    'VIEW_USER',\r
+    'VIEW_USER_FINES_SUMMARY',\r
+    'VIEW_USER_TRANSACTIONS'\r
+);\r
 </userinput>\r
 </screen>\r
                                        \r