From 9bfd772f2b58e5e236e6b81912f2a683b5d8207d Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Thu, 18 Oct 2007 17:30:02 +0000
Subject: Correcting some issues with roles files.  There are still a few
 syntax errors.  Still working on them.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1786 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/modules/Roles.sql | 60 +++++++++++++++++++++++++--------------------------
 1 file changed, 30 insertions(+), 30 deletions(-)

(limited to 'sql')

diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql
index 1de3d3f0..0629c80a 100644
--- a/sql/modules/Roles.sql
+++ b/sql/modules/Roles.sql
@@ -2,43 +2,43 @@
 CREATE ROLE lsmb_<?lsmb dbname ?>__read_contact
 WITH INHERIT NOLOGIN;
 
-GRANT SELECT ON entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON company TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON person TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON entity_credit_account TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON company_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON company_to_entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON company_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON customertax TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON employee TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON customer TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON contact_class TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON entity_class TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON entity_bank_account TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON entity_note TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON entity_class_to_entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON entity_other_name TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON location_class TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON person_to_company TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON person_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON person_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON person_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON person_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT SELECT ON vendortax TO lsmb_<?lsmb dbname ?>__create_contact;
+GRANT SELECT ON entity TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON company TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON location TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON person TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON entity_credit_account TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON company_to_contact TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON company_to_entity TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON company_to_location TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON customertax TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON employee TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON customer TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON contact_class TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON entity_class TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON entity_bank_account TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON entity_note TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON entity_class_to_entity TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON entity_other_name TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON location_class TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON person_to_company TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON person_to_contact TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON person_to_contact TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON person_to_location TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON person_to_location TO lsmb_<?lsmb dbname ?>__read_contact;
+GRANT SELECT ON vendortax TO lsmb_<?lsmb dbname ?>__read_contact;
 
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
-values (1, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
+values (1, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
-values (11, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
+values (11, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
-values (14, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
+values (14, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
-values (21, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
+values (21, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
-values (30, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
+values (30, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
-values (33, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
+values (33, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
 
 
 CREATE ROLE lsmb_<?lsmb dbname ?>__create_contact
-- 
cgit v1.2.3