From 1dfdccb8118aeaa3cd844ac8de2a672c93312166 Mon Sep 17 00:00:00 2001
From: mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219>
Date: Sat, 21 Feb 2009 21:44:27 +0000
Subject: git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2
 da190166-9cfc-4ee1-ae03-434a172be219

---
 slips/build/sql/ddl/security.sql.template | 40 +++++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 slips/build/sql/ddl/security.sql.template

(limited to 'slips/build/sql/ddl/security.sql.template')

diff --git a/slips/build/sql/ddl/security.sql.template b/slips/build/sql/ddl/security.sql.template
new file mode 100644
index 0000000..27c5e22
--- /dev/null
+++ b/slips/build/sql/ddl/security.sql.template
@@ -0,0 +1,40 @@
+use [@initial.catalog@]
+GO
+IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'@asp.net.account@')
+CREATE LOGIN [@asp.net.account@] FROM WINDOWS WITH DEFAULT_DATABASE=[@initial.catalog@]
+GO
+
+if not exists (select * from dbo.sysusers where name = N'@asp.net.account@' and uid < 16382)
+	EXEC sp_grantdbaccess N'@asp.net.account@', N'@asp.net.account@'
+GO
+
+if not exists (select * from dbo.sysusers where name = N'WebUser' and uid > 16399)
+	EXEC sp_addrole N'WebUser'
+GO
+
+exec sp_addrolemember N'WebUser', N'@asp.net.account@'
+GO
+
+use [@initial.catalog@]
+GO
+
+GRANT SELECT ON Dock TO WebUser;
+GRANT SELECT ON LeaseType TO WebUser;
+GRANT SELECT ON Location TO WebUser;
+GRANT SELECT ON Slip TO WebUser;
+GRANT SELECT ON Lease TO WebUser;
+GRANT SELECT ON Customer TO WebUser;
+GRANT SELECT ON Authorize TO WebUser;
+GRANT SELECT ON Boat TO WebUser;
+
+GRANT UPDATE ON Customer TO WebUser;
+GRANT UPDATE ON Authorize TO WebUser;
+
+GRANT INSERT ON Authorize TO WebUser;
+GRANT INSERT ON Boat TO WebUser;
+GRANT INSERT ON Customer TO WebUser;
+GRANT INSERT ON Lease TO WebUser;
+
+GRANT DELETE ON Boat TO WebUser;
+GRANT DELETE ON Lease TO WebUser;
+GO
-- 
cgit v1.2.3