From 58ee21a393110117a14437458e26364ed2902e53 Mon Sep 17 00:00:00 2001
From: dbs <dbs@6d9bc8c9-1ec2-4278-b937-99fde70a366f>
Date: Tue, 31 Mar 2009 00:14:57 +0000
Subject: [PATCH] Basic user group / permissions for SIP clients

git-svn-id: svn://svn.open-ils.org/ILS-Contrib/conifer/trunk@233 6d9bc8c9-1ec2-4278-b937-99fde70a366f
---
 tools/sip_user.sql | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 tools/sip_user.sql

diff --git a/tools/sip_user.sql b/tools/sip_user.sql
new file mode 100644
index 0000000000..1295a86b1d
--- /dev/null
+++ b/tools/sip_user.sql
@@ -0,0 +1,29 @@
+-- Basic SQL for setting up SIP client user group and associated permissions
+BEGIN;
+
+-- Create the SIP user group
+INSERT INTO permission.grp_tree (name, parent, usergroup, perm_interval, description, application_perm)
+	VALUES ('SIP-Client', 1, 't', '3 years', 'SIP server interactions', 'group_application.user.sip-client');
+
+-- Create the permissions for the SIP user group
+INSERT INTO permission.grp_perm_map (grp, depth, perm)
+	SELECT currval('permission.grp_tree_id_seq'), 0, id
+	FROM permission.perm_list
+	WHERE code IN (
+		'COPY_CHECKIN',
+		'COPY_CHECKOUT',
+		'RENEW_CIRC',
+		'VIEW_CIRCULATIONS',
+		'VIEW_COPY_CHECKOUT_HISTORY',
+		'VIEW_PERMIT_CHECKOUT',
+		'VIEW_USER',
+		'VIEW_USER_FINES_SUMMARY',
+		'VIEW_USER_TRANSACTIONS'
+	)
+;
+
+-- Give local system administrators (10) the permission (135) to create a SIP-Client user
+INSERT INTO permission.grp_perm_map (grp, perm, depth)
+	VALUES (10, 135, 0);
+
+COMMIT;
-- 
2.11.0