Updating Roles.sql to allow hyphens in db names

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2112 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 392 insertions, 392 deletions

diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql
index 80c98771..2f4a2c8f 100644
--- a/sql/modules/Roles.sql
+++ b/sql/modules/Roles.sql
@@ -1,31 +1,31 @@
 GRANT ALL ON SCHEMA public TO public; -- required for Pg 8.2
 -- Contacts
-CREATE ROLE lsmb_<?lsmb dbname ?>__read_contact
+CREATE ROLE "lsmb_<?lsmb dbname ?>__read_contact"
 WITH INHERIT NOLOGIN;
 
-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 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 company_to_location TO lsmb_<?lsmb dbname ?>__read_contact;
-GRANT SELECT ON vendortax TO lsmb_<?lsmb dbname ?>__read_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 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 company_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 ?>__read_contact');
@@ -41,38 +41,38 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (33, 'allow', 'lsmb_<?lsmb dbname ?>__read_contact');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_contact
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_contact"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
-
-GRANT INSERT ON entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT ALL ON entity_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON company TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT ALL ON company_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT ALL ON location_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON person TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT ALL ON person_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON entity_credit_account TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT ALL ON entity_credit_account_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON company_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON company_to_entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT ALL ON SEQUENCE not_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON company_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON customertax TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON entity_bank_account TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT ALL ON entity_bank_account_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON entity_note TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON entity_class_to_entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON entity_other_name TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON person_to_company TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON person_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON person_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON person_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON person_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON company_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT DELETE ON company_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT INSERT ON vendortax TO lsmb_<?lsmb dbname ?>__create_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
+
+GRANT INSERT ON entity TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT ALL ON entity_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON company TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT ALL ON company_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT ALL ON location_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON person TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT ALL ON person_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON entity_credit_account TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT ALL ON entity_credit_account_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON company_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON company_to_entity TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT ALL ON SEQUENCE not_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON company_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON customertax TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON entity_bank_account TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT ALL ON entity_bank_account_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON entity_note TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON entity_class_to_entity TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON entity_other_name TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON person_to_company TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON person_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON person_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON person_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON person_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON company_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT DELETE ON company_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT INSERT ON vendortax TO "lsmb_<?lsmb dbname ?>__create_contact";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name) 
 values (1, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
@@ -88,68 +88,68 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (31, 'allow', 'lsmb_<?lsmb dbname ?>__create_contact');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_contact
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_contact"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
-
-GRANT UPDATE ON entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON company TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON person TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON entity_credit_account TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON company_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON company_to_entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON company_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON customertax TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON entity_bank_account TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON entity_note TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON entity_class_to_entity TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON entity_other_name TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON person_to_company TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON person_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON person_to_contact TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON person_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT UPDATE ON person_to_location TO lsmb_<?lsmb dbname ?>__create_contact;
-GRANT DELETE, INSERT  ON vendortax TO lsmb_<?lsmb dbname ?>__create_contact;
-
-CREATE ROLE lsmb_<?lsmb dbname ?>__contact_all_rights
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
+
+GRANT UPDATE ON entity TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON company TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON person TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON entity_credit_account TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON company_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON company_to_entity TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON company_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON customertax TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON entity_bank_account TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON entity_note TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON entity_class_to_entity TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON entity_other_name TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON person_to_company TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON person_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON person_to_contact TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON person_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT UPDATE ON person_to_location TO "lsmb_<?lsmb dbname ?>__create_contact";
+GRANT DELETE, INSERT  ON vendortax TO "lsmb_<?lsmb dbname ?>__create_contact";
+
+CREATE ROLE "lsmb_<?lsmb dbname ?>__contact_all_rights"
 WITH INHERIT NOLOGIN 
-in role lsmb_<?lsmb dbname ?>__create_contact, 
+in role "lsmb_<?lsmb dbname ?>__create_contact", 
 lsmb_<?lsmb dbname ?>__edit_contact,
 lsmb_<?lsmb dbname ?>__read_contact;
 
 -- Batches and VOuchers
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_batch
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_batch"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON batch TO lsmb_<?lsmb dbname ?>__create_batch;
-GRANT ALL ON batch_id_seq TO lsmb_<?lsmb dbname ?>__create_batch;
-GRANT SELECT ON batch_class TO lsmb_<?lsmb dbname ?>__create_batch;
-GRANT INSERT ON voucher TO lsmb_<?lsmb dbname ?>__create_batch;
-GRANT ALL ON voucher_id_seq TO lsmb_<?lsmb dbname ?>__create_contact;
+GRANT INSERT ON batch TO "lsmb_<?lsmb dbname ?>__create_batch";
+GRANT ALL ON batch_id_seq TO "lsmb_<?lsmb dbname ?>__create_batch";
+GRANT SELECT ON batch_class TO "lsmb_<?lsmb dbname ?>__create_batch";
+GRANT INSERT ON voucher TO "lsmb_<?lsmb dbname ?>__create_batch";
+GRANT ALL ON voucher_id_seq TO "lsmb_<?lsmb dbname ?>__create_contact";
 
 -- TODO add Menu ACLs
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__post_batches
+CREATE ROLE "lsmb_<?lsmb dbname ?>__post_batches"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON ar TO lsmb_<?lsmb dbname ?>__post_batches;
-GRANT UPDATE ON ap TO lsmb_<?lsmb dbname ?>__post_batches;
-GRANT UPDATE ON acc_trans TO lsmb_<?lsmb dbname ?>__post_batches;
-GRANT UPDATE ON batch TO lsmb_<?lsmb dbname ?>__post_batches;
-GRANT UPDATE ON gl TO lsmb_<?lsmb dbname ?>__post_batches;
+GRANT UPDATE ON ar TO "lsmb_<?lsmb dbname ?>__post_batches";
+GRANT UPDATE ON ap TO "lsmb_<?lsmb dbname ?>__post_batches";
+GRANT UPDATE ON acc_trans TO "lsmb_<?lsmb dbname ?>__post_batches";
+GRANT UPDATE ON batch TO "lsmb_<?lsmb dbname ?>__post_batches";
+GRANT UPDATE ON gl TO "lsmb_<?lsmb dbname ?>__post_batches";
 
 -- TODO add Menu ACLs
 
 -- AR
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ar_transaction
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ar_transaction"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON ar TO lsmb_<?lsmb dbname ?>__create_ar_transaction;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__create_ar_transaction;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__create_ar_transaction;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ar_transaction;
+GRANT INSERT ON ar TO "lsmb_<?lsmb dbname ?>__create_ar_transaction";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__create_ar_transaction";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__create_ar_transaction";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ar_transaction";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (1, 'allow', 'lsmb_<?lsmb dbname ?>__create_ar_transaction');
@@ -158,27 +158,27 @@ values (2, 'allow', 'lsmb_<?lsmb dbname ?>__create_ar_transaction');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (194, 'allow', 'lsmb_<?lsmb dbname ?>__create_ar_transaction');
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact,
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
 lsmb_<?lsmb dbname ?>__create_batch;
 
-GRANT INSERT ON ar TO lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher;
+GRANT INSERT ON ar TO "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher";
 
 -- TODO add Menu ACLs
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ar_invoice
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ar_invoice"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact,
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
 lsmb_<?lsmb dbname ?>__create_ar_transaction;
 
-GRANT INSERT ON invoice TO lsmb_<?lsmb dbname ?>__create_ar_invoice;
-GRANT ALL ON invoice_id_seq TO lsmb_<?lsmb dbname ?>__create_ar_invoice;
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__create_ar_invoice;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ar_invoice;
+GRANT INSERT ON invoice TO "lsmb_<?lsmb dbname ?>__create_ar_invoice";
+GRANT ALL ON invoice_id_seq TO "lsmb_<?lsmb dbname ?>__create_ar_invoice";
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__create_ar_invoice";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ar_invoice";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (3, 'allow', 'lsmb_<?lsmb dbname ?>__create_ar_invoice');
@@ -186,27 +186,27 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (195, 'allow', 'lsmb_<?lsmb dbname ?>__create_ar_transaction');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact,
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
 lsmb_<?lsmb dbname ?>__create_batch,
 lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher;
 
-GRANT INSERT ON invoice TO lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher;
-GRANT ALL ON invoice_id_seq TO lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher;
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher;
+GRANT INSERT ON invoice TO "lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher";
+GRANT ALL ON invoice_id_seq TO "lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher";
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher";
 
 -- TODO add Menu ACLs
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_ar_transactions
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_ar_transactions"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT SELECT ON ar TO lsmb_<?lsmb dbname ?>__list_ar_transactions;
-GRANT SELECT ON acc_trans TO lsmb_<?lsmb dbname ?>__list_ar_transactions;
-GRANT SELECT ON invoice TO lsmb_<?lsmb dbname ?>__list_ar_transactions;
-GRANT SELECT ON inventory TO lsmb_<?lsmb dbname ?>__list_ar_transactions;
+GRANT SELECT ON ar TO "lsmb_<?lsmb dbname ?>__list_ar_transactions";
+GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__list_ar_transactions";
+GRANT SELECT ON invoice TO "lsmb_<?lsmb dbname ?>__list_ar_transactions";
+GRANT SELECT ON inventory TO "lsmb_<?lsmb dbname ?>__list_ar_transactions";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (1, 'allow', 'lsmb_<?lsmb dbname ?>__list_ar_transactions');
@@ -229,25 +229,25 @@ values (13, 'allow', 'lsmb_<?lsmb dbname ?>__list_ar_transactions');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (15, 'allow', 'lsmb_<?lsmb dbname ?>__list_ar_transactions');
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__ar_all_vouchers
+CREATE ROLE "lsmb_<?lsmb dbname ?>__ar_all_vouchers"
 WITH INHERIT NOLOGIN 
-IN ROLE lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher",
 lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__ar_all_transactions
+CREATE ROLE "lsmb_<?lsmb dbname ?>__ar_all_transactions"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_ar_transaction,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_ar_transaction",
 lsmb_<?lsmb dbname ?>__create_ar_invoice,
 lsmb_<?lsmb dbname ?>__list_ar_transactions;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_sales_order
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_sales_order"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON oe TO lsmb_<?lsmb dbname ?>__create_sales_order;
-GRANT ALL ON oe_id_seq TO lsmb_<?lsmb dbname ?>__create_sales_order;
-GRANT INSERT ON orderitems TO lsmb_<?lsmb dbname ?>__create_sales_order;
-GRANT ALL ON orderitems_id_seq TO lsmb_<?lsmb dbname ?>__create_sales_order;
+GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__create_sales_order";
+GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__create_sales_order";
+GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__create_sales_order";
+GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__create_sales_order";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__create_sales_order');
@@ -255,14 +255,14 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (51, 'allow', 'lsmb_<?lsmb dbname ?>__create_sales_order');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_sales_quotation
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_sales_quotation"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON oe TO lsmb_<?lsmb dbname ?>__create_sales_quotation;
-GRANT ALL ON oe_id_seq TO lsmb_<?lsmb dbname ?>__create_sales_quotation;
-GRANT INSERT ON orderitems TO lsmb_<?lsmb dbname ?>__create_sales_quotation;
-GRANT ALL ON orderitems_id_seq TO lsmb_<?lsmb dbname ?>__create_sales_quotation;
+GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__create_sales_quotation";
+GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__create_sales_quotation";
+GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__create_sales_quotation";
+GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__create_sales_quotation";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (67, 'allow', 'lsmb_<?lsmb dbname ?>__create_sales_quotation');
@@ -270,12 +270,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (68, 'allow', 'lsmb_<?lsmb dbname ?>__create_sales_quotation');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_sales_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_sales_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT SELECT ON oe TO lsmb_<?lsmb dbname ?>__list_sales_orders;
-GRANT SELECT ON orderitems TO lsmb_<?lsmb dbname ?>__list_sales_orders;
+GRANT SELECT ON oe TO "lsmb_<?lsmb dbname ?>__list_sales_orders";
+GRANT SELECT ON orderitems TO "lsmb_<?lsmb dbname ?>__list_sales_orders";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__list_sales_orders');
@@ -285,12 +285,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (54, 'allow', 'lsmb_<?lsmb dbname ?>__list_sales_orders');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_sales_quotations
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_sales_quotations"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT SELECT ON oe TO lsmb_<?lsmb dbname ?>__list_sales_quotations;
-GRANT SELECT ON orderitems TO lsmb_<?lsmb dbname ?>__list_sales_quotations;
+GRANT SELECT ON oe TO "lsmb_<?lsmb dbname ?>__list_sales_quotations";
+GRANT SELECT ON orderitems TO "lsmb_<?lsmb dbname ?>__list_sales_quotations";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (67, 'allow', 'lsmb_<?lsmb dbname ?>__list_sales_quotations');
@@ -300,9 +300,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (71, 'allow', 'lsmb_<?lsmb dbname ?>__list_sales_quotations');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_ar
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_ar"
 WITH INHERIT NOLOGIN 
-IN ROLE lsmb_<?lsmb dbname ?>__ar_all_vouchers,
+IN ROLE "lsmb_<?lsmb dbname ?>__ar_all_vouchers",
 lsmb_<?lsmb dbname ?>__ar_all_transactions,
 lsmb_<?lsmb dbname ?>__create_sales_order,
 lsmb_<?lsmb dbname ?>__create_sales_quotation,
@@ -310,14 +310,14 @@ lsmb_<?lsmb dbname ?>__list_sales_orders,
 lsmb_<?lsmb dbname ?>__list_sales_quotations;
 
 -- AP
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ap_transaction
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON ap TO lsmb_<?lsmb dbname ?>__create_ap_transaction;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__create_ap_transaction;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__create_ap_transaction;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ap_transaction;
+GRANT INSERT ON ap TO "lsmb_<?lsmb dbname ?>__create_ap_transaction";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__create_ap_transaction";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__create_ap_transaction";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ap_transaction";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (21, 'allow', 'lsmb_<?lsmb dbname ?>__create_ap_transaction');
@@ -326,27 +326,27 @@ values (22, 'allow', 'lsmb_<?lsmb dbname ?>__create_ap_transaction');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (196, 'allow', 'lsmb_<?lsmb dbname ?>__create_ap_transaction');
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact,
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
 lsmb_<?lsmb dbname ?>__create_batch;
 
-GRANT INSERT ON ar TO lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher;
+GRANT INSERT ON ar TO "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher";
 
 -- TODO add Menu ACLs
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ap_invoice
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_invoice"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact,
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
 lsmb_<?lsmb dbname ?>__create_ap_transaction;
 
-GRANT INSERT ON invoice TO lsmb_<?lsmb dbname ?>__create_ap_invoice;
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__create_ap_invoice;
-GRANT ALL ON invoice_id_seq TO lsmb_<?lsmb dbname ?>__create_ap_invoice;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ap_invoice;
+GRANT INSERT ON invoice TO "lsmb_<?lsmb dbname ?>__create_ap_invoice";
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__create_ap_invoice";
+GRANT ALL ON invoice_id_seq TO "lsmb_<?lsmb dbname ?>__create_ap_invoice";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ap_invoice";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (23, 'allow', 'lsmb_<?lsmb dbname ?>__create_ap_invoice');
@@ -354,27 +354,27 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (197, 'allow', 'lsmb_<?lsmb dbname ?>__create_ap_transaction');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact,
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
 lsmb_<?lsmb dbname ?>__create_batch;
 
-GRANT INSERT ON invoice TO lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher;
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher;
-GRANT ALL ON invoice_id_seq TO lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher;
+GRANT INSERT ON invoice TO "lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher";
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher";
+GRANT ALL ON invoice_id_seq TO "lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher";
 
 -- TODO add Menu ACLs
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_ap_transactions
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_ap_transactions"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT SELECT ON ap TO lsmb_<?lsmb dbname ?>__list_ap_transactions;
-GRANT SELECT ON acc_trans TO lsmb_<?lsmb dbname ?>__list_ap_transactions;
-GRANT SELECT ON invoice TO lsmb_<?lsmb dbname ?>__list_ap_transactions;
-GRANT SELECT ON inventory TO lsmb_<?lsmb dbname ?>__list_ap_transactions;
+GRANT SELECT ON ap TO "lsmb_<?lsmb dbname ?>__list_ap_transactions";
+GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__list_ap_transactions";
+GRANT SELECT ON invoice TO "lsmb_<?lsmb dbname ?>__list_ap_transactions";
+GRANT SELECT ON inventory TO "lsmb_<?lsmb dbname ?>__list_ap_transactions";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (21, 'allow', 'lsmb_<?lsmb dbname ?>__list_ap_transactions');
@@ -398,25 +398,25 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (34, 'allow', 'lsmb_<?lsmb dbname ?>__list_ap_transactions');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__ap_all_vouchers
+CREATE ROLE "lsmb_<?lsmb dbname ?>__ap_all_vouchers"
 WITH INHERIT NOLOGIN 
-IN ROLE lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher",
 lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__ap_all_transactions
+CREATE ROLE "lsmb_<?lsmb dbname ?>__ap_all_transactions"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_ap_transaction,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction",
 lsmb_<?lsmb dbname ?>__create_ap_invoice,
 lsmb_<?lsmb dbname ?>__list_ap_transactions;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_purchase_order
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_purchase_order"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON oe TO lsmb_<?lsmb dbname ?>__create_purchase_order;
-GRANT INSERT ON orderitems TO lsmb_<?lsmb dbname ?>__create_purchase_order;
-GRANT ALL ON oe_id_seq TO lsmb_<?lsmb dbname ?>__create_purchase_order;
-GRANT ALL ON orderitems_id_seq TO lsmb_<?lsmb dbname ?>__create_purchase_order;
+GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__create_purchase_order";
+GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__create_purchase_order";
+GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__create_purchase_order";
+GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__create_purchase_order";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__create_purchase_order');
@@ -424,14 +424,14 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (52, 'allow', 'lsmb_<?lsmb dbname ?>__create_purchase_order');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_purchase_rfq
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_purchase_rfq"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON oe TO lsmb_<?lsmb dbname ?>__create_purchase_rfq;
-GRANT INSERT ON orderitems TO lsmb_<?lsmb dbname ?>__create_purchase_rfq;
-GRANT ALL ON oe_id_seq TO lsmb_<?lsmb dbname ?>__create_purchase_rfq;
-GRANT ALL ON orderitems_id_seq TO lsmb_<?lsmb dbname ?>__create_purchase_rfq;
+GRANT INSERT ON oe TO "lsmb_<?lsmb dbname ?>__create_purchase_rfq";
+GRANT INSERT ON orderitems TO "lsmb_<?lsmb dbname ?>__create_purchase_rfq";
+GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__create_purchase_rfq";
+GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__create_purchase_rfq";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (67, 'allow', 'lsmb_<?lsmb dbname ?>__create_purchase_rfq');
@@ -439,12 +439,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (69, 'allow', 'lsmb_<?lsmb dbname ?>__create_purchase_rfq');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_purchase_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_purchase_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT SELECT ON oe TO lsmb_<?lsmb dbname ?>__list_purchase_orders;
-GRANT SELECT ON orderitems TO lsmb_<?lsmb dbname ?>__list_purchase_orders;
+GRANT SELECT ON oe TO "lsmb_<?lsmb dbname ?>__list_purchase_orders";
+GRANT SELECT ON orderitems TO "lsmb_<?lsmb dbname ?>__list_purchase_orders";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__list_purchase_orders');
@@ -454,12 +454,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (55, 'allow', 'lsmb_<?lsmb dbname ?>__list_purchase_orders');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_purchase_rfqs
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_purchase_rfqs"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT SELECT ON oe TO lsmb_<?lsmb dbname ?>__list_purchase_rfqs;
-GRANT SELECT ON orderitems TO lsmb_<?lsmb dbname ?>__list_purchase_rfqs;
+GRANT SELECT ON oe TO "lsmb_<?lsmb dbname ?>__list_purchase_rfqs";
+GRANT SELECT ON orderitems TO "lsmb_<?lsmb dbname ?>__list_purchase_rfqs";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (67, 'allow', 'lsmb_<?lsmb dbname ?>__list_purchase_rfqs');
@@ -469,9 +469,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (72, 'allow', 'lsmb_<?lsmb dbname ?>__list_purchase_rfqs');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_ap
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_ap"
 WITH INHERIT NOLOGIN 
-IN ROLE lsmb_<?lsmb dbname ?>__ap_all_vouchers,
+IN ROLE "lsmb_<?lsmb dbname ?>__ap_all_vouchers",
 lsmb_<?lsmb dbname ?>__ap_all_transactions,
 lsmb_<?lsmb dbname ?>__create_purchase_order,
 lsmb_<?lsmb dbname ?>__create_purchase_rfq,
@@ -479,18 +479,18 @@ lsmb_<?lsmb dbname ?>__list_purchase_orders,
 lsmb_<?lsmb dbname ?>__list_purchase_rfqs;
 
 -- POS
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_pos_invoice
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_pos_invoice"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON invoice TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
-GRANT INSERT ON ar TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
-GRANT ALL ON invoice_id_seq TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_pos_invoice;
+GRANT INSERT ON invoice TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
+GRANT INSERT ON ar TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
+GRANT ALL ON invoice_id_seq TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_pos_invoice";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (16, 'allow', 'lsmb_<?lsmb dbname ?>__create_pos_invoice');
@@ -500,13 +500,13 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (18, 'allow', 'lsmb_<?lsmb dbname ?>__create_pos_invoice');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__close_till
+CREATE ROLE "lsmb_<?lsmb dbname ?>__close_till"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON gl TO lsmb_<?lsmb dbname ?>__close_till;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__close_till;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__close_till;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__close_till;
+GRANT INSERT ON gl TO "lsmb_<?lsmb dbname ?>__close_till";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__close_till";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__close_till";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__close_till";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (16, 'allow', 'lsmb_<?lsmb dbname ?>__close_till');
@@ -514,11 +514,11 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (19, 'allow', 'lsmb_<?lsmb dbname ?>__close_till');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_all_open
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_all_open"
 WITH INHERIT NOLOGIN;
 
-GRANT SELECT ON ar TO lsmb_<?lsmb dbname ?>__list_all_open;
-GRANT SELECT ON acc_trans TO lsmb_<?lsmb dbname ?>__list_all_open;
+GRANT SELECT ON ar TO "lsmb_<?lsmb dbname ?>__list_all_open";
+GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__list_all_open";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (16, 'allow', 'lsmb_<?lsmb dbname ?>__list_all_open');
@@ -526,25 +526,25 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (18, 'allow', 'lsmb_<?lsmb dbname ?>__list_all_open');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__pos_cashier
+CREATE ROLE "lsmb_<?lsmb dbname ?>__pos_cashier"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_pos_invoice,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_pos_invoice",
 lsmb_<?lsmb dbname ?>__close_till;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_pos
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_pos"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__pos_cashier,
+IN ROLE "lsmb_<?lsmb dbname ?>__pos_cashier",
 lsmb_<?lsmb dbname ?>__list_all_open;
 
 -- CASH
-CREATE ROLE lsmb_<?lsmb dbname ?>__reconcile
+CREATE ROLE "lsmb_<?lsmb dbname ?>__reconcile"
 WITH INHERIT NOLOGIN;
 
--- GRANT INSERT ON pending_reports TO lsmb_<?lsmb dbname ?>__reconcile;
--- GRANT INSERT on report_corrections TO lsmb_<?lsmb dbname ?>__reconcile;
-GRANT SELECT ON acc_trans TO lsmb_<?lsmb dbname ?>__reconcile;
--- GRANT ALL ON pending_reports_id_seq TO lsmb_<?lsmb dbname ?>__reconcile;
--- GRANT ALL ON report_corrections_id_seq TO lsmb_<?lsmb dbname ?>__reconcile;
+-- GRANT INSERT ON pending_reports TO "lsmb_<?lsmb dbname ?>__reconcile";
+-- GRANT INSERT on report_corrections TO "lsmb_<?lsmb dbname ?>__reconcile";
+GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__reconcile";
+-- GRANT ALL ON pending_reports_id_seq TO "lsmb_<?lsmb dbname ?>__reconcile";
+-- GRANT ALL ON report_corrections_id_seq TO "lsmb_<?lsmb dbname ?>__reconcile";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (35, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
@@ -552,11 +552,11 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (45, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__approve_reconciliation
+CREATE ROLE "lsmb_<?lsmb dbname ?>__approve_reconciliation"
 WITH INHERIT NOLOGIN;
 
--- GRANT UPDATE ON pending_reports TO lsmb_<?lsmb dbname ?>__reconcile;
-GRANT SELECT ON acc_trans TO lsmb_<?lsmb dbname ?>__reconcile;
+-- GRANT UPDATE ON pending_reports TO "lsmb_<?lsmb dbname ?>__reconcile";
+GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__reconcile";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (35, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
@@ -566,17 +566,17 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (44, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_reconcile
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_reconcile"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__reconcile,
+IN ROLE "lsmb_<?lsmb dbname ?>__reconcile",
 lsmb_<?lsmb dbname ?>__approve_reconciliation;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__process_payment
+CREATE ROLE "lsmb_<?lsmb dbname ?>__process_payment"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_ap_transactions;
+IN ROLE "lsmb_<?lsmb dbname ?>__list_ap_transactions";
 
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__process_payment;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__process_payment;
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_payment";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_payment";
 
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
@@ -587,12 +587,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (39, 'allow', 'lsmb_<?lsmb dbname ?>__process_payment');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__process_receipt
+CREATE ROLE "lsmb_<?lsmb dbname ?>__process_receipt"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__ar_list_transactions;
+IN ROLE "lsmb_<?lsmb dbname ?>__ar_list_transactions";
 
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__process_receipt;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__process_receipt;
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__process_receipt";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__process_receipt";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (35, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt');
@@ -602,18 +602,18 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (47, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__cash_all
+CREATE ROLE "lsmb_<?lsmb dbname ?>__cash_all"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__all_reconcile,
+IN ROLE "lsmb_<?lsmb dbname ?>__all_reconcile",
 lsmb_<?lsmb dbname ?>__process_payment,
 lsmb_<?lsmb dbname ?>__process_receipt;
 
 -- Inventory Control
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_part
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_part"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON parts TO lsmb_<?lsmb dbname ?>__create_part;
-GRANT ALL ON parts_id_seq TO lsmb_<?lsmb dbname ?>__create_part;
+GRANT INSERT ON parts TO "lsmb_<?lsmb dbname ?>__create_part";
+GRANT ALL ON parts_id_seq TO "lsmb_<?lsmb dbname ?>__create_part";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (77, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
@@ -629,10 +629,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (82, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_part
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_part"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON parts TO lsmb_<?lsmb dbname ?>__edit_part;
+GRANT UPDATE ON parts TO "lsmb_<?lsmb dbname ?>__edit_part";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (77, 'allow', 'lsmb_<?lsmb dbname ?>__edit_part');
@@ -654,14 +654,14 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (93, 'allow', 'lsmb_<?lsmb dbname ?>__edit_part');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__inventory_reports
+CREATE ROLE "lsmb_<?lsmb dbname ?>__inventory_reports"
 WITH INHERIT NOLOGIN;
 
-GRANT SELECT ON ar TO lsmb_<?lsmb dbname ?>__inventory_reports;
-GRANT SELECT ON ap TO lsmb_<?lsmb dbname ?>__inventory_reports;
-GRANT SELECT ON inventory TO lsmb_<?lsmb dbname ?>__inventory_reports;
-GRANT SELECT ON invoice TO lsmb_<?lsmb dbname ?>__inventory_reports;
-GRANT SELECT ON acc_trans TO lsmb_<?lsmb dbname ?>__inventory_reports;
+GRANT SELECT ON ar TO "lsmb_<?lsmb dbname ?>__inventory_reports";
+GRANT SELECT ON ap TO "lsmb_<?lsmb dbname ?>__inventory_reports";
+GRANT SELECT ON inventory TO "lsmb_<?lsmb dbname ?>__inventory_reports";
+GRANT SELECT ON invoice TO "lsmb_<?lsmb dbname ?>__inventory_reports";
+GRANT SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__inventory_reports";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (77, 'allow', 'lsmb_<?lsmb dbname ?>__inventory_reports');
@@ -673,13 +673,13 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (94, 'allow', 'lsmb_<?lsmb dbname ?>__inventory_reports');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_pricegroup
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_pricegroup"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON pricegroup TO lsmb_<?lsmb dbname ?>__create_pricegroup;
-GRANT ALL ON pricegroup_id_seq TO lsmb_<?lsmb dbname ?>__create_pricegroup;
-GRANT UPDATE ON entity_credit_account TO lsmb_<?lsmb dbname ?>__create_pricegroup;
+GRANT INSERT ON pricegroup TO "lsmb_<?lsmb dbname ?>__create_pricegroup";
+GRANT ALL ON pricegroup_id_seq TO "lsmb_<?lsmb dbname ?>__create_pricegroup";
+GRANT UPDATE ON entity_credit_account TO "lsmb_<?lsmb dbname ?>__create_pricegroup";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (77, 'allow', 'lsmb_<?lsmb dbname ?>__create_pricegroup');
@@ -687,12 +687,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (83, 'allow', 'lsmb_<?lsmb dbname ?>__create_pricegroup');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_pricegroup
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_pricegroup"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT UPDATE ON pricegroup TO lsmb_<?lsmb dbname ?>__edit_pricegroup;
-GRANT UPDATE ON entity_credit_account TO lsmb_<?lsmb dbname ?>__edit_pricegroup;
+GRANT UPDATE ON pricegroup TO "lsmb_<?lsmb dbname ?>__edit_pricegroup";
+GRANT UPDATE ON entity_credit_account TO "lsmb_<?lsmb dbname ?>__edit_pricegroup";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (77, 'allow', 'lsmb_<?lsmb dbname ?>__edit_pricegroup');
@@ -701,10 +701,10 @@ values (85, 'allow', 'lsmb_<?lsmb dbname ?>__edit_pricegroup');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (92, 'allow', 'lsmb_<?lsmb dbname ?>__edit_pricegroup');
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__stock_assembly
+CREATE ROLE "lsmb_<?lsmb dbname ?>__stock_assembly"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON parts TO lsmb_<?lsmb dbname ?>__stock_assembly;
+GRANT UPDATE ON parts TO "lsmb_<?lsmb dbname ?>__stock_assembly";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (77, 'allow', 'lsmb_<?lsmb dbname ?>__stock_assembly');
@@ -712,12 +712,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (84, 'allow', 'lsmb_<?lsmb dbname ?>__stock_assembly');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__ship_inventory
+CREATE ROLE "lsmb_<?lsmb dbname ?>__ship_inventory"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_sales_orders;
+IN ROLE "lsmb_<?lsmb dbname ?>__list_sales_orders";
 
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__ship_inventory;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__ship_inventory;
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__ship_inventory";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__ship_inventory";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (63, 'allow', 'lsmb_<?lsmb dbname ?>__ship_inventory');
@@ -725,12 +725,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (64, 'allow', 'lsmb_<?lsmb dbname ?>__ship_inventory');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__receive_inventory
+CREATE ROLE "lsmb_<?lsmb dbname ?>__receive_inventory"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_purchase_orders;
+IN ROLE "lsmb_<?lsmb dbname ?>__list_purchase_orders";
 
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__receive_inventory;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__receive_inventory;
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__receive_inventory";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__receive_inventory";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (63, 'allow', 'lsmb_<?lsmb dbname ?>__receive_inventory');
@@ -738,22 +738,22 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (65, 'allow', 'lsmb_<?lsmb dbname ?>__receive_inventory');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__transfer_inventory
+CREATE ROLE "lsmb_<?lsmb dbname ?>__transfer_inventory"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON inventory TO lsmb_<?lsmb dbname ?>__transfer_inventory;
-GRANT ALL ON inventory_entry_id_seq TO lsmb_<?lsmb dbname ?>__transfer_inventory;
+GRANT INSERT ON inventory TO "lsmb_<?lsmb dbname ?>__transfer_inventory";
+GRANT ALL ON inventory_entry_id_seq TO "lsmb_<?lsmb dbname ?>__transfer_inventory";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (63, 'allow', 'lsmb_<?lsmb dbname ?>__transfer_inventory');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (66, 'allow', 'lsmb_<?lsmb dbname ?>__transfer_inventory');
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_warehouse
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_warehouse"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON warehouse TO lsmb_<?lsmb dbname ?>__create_warehouse;
-GRANT ALL ON warehouse_id_seq TO lsmb_<?lsmb dbname ?>__create_warehouse;
+GRANT INSERT ON warehouse TO "lsmb_<?lsmb dbname ?>__create_warehouse";
+GRANT ALL ON warehouse_id_seq TO "lsmb_<?lsmb dbname ?>__create_warehouse";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__create_warehouse');
@@ -763,10 +763,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (142, 'allow', 'lsmb_<?lsmb dbname ?>__create_warehouse');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_warehouse
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_warehouse"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON warehouse TO lsmb_<?lsmb dbname ?>__edit_warehouse;
+GRANT UPDATE ON warehouse TO "lsmb_<?lsmb dbname ?>__edit_warehouse";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__edit_warehouse');
@@ -776,9 +776,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (143, 'allow', 'lsmb_<?lsmb dbname ?>__edit_warehouse');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_inventory
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_inventory"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_part,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_part",
 lsmb_<?lsmb dbname ?>__inventory_reports,
 lsmb_<?lsmb dbname ?>__stock_assembly,
 lsmb_<?lsmb dbname ?>__ship_inventory,
@@ -788,13 +788,13 @@ lsmb_<?lsmb dbname ?>__edit_warehouse,
 lsmb_<?lsmb dbname ?>__create_warehouse;
 
 -- GL 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_transaction
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_transaction"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON gl TO lsmb_<?lsmb dbname ?>__create_transaction;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__create_transaction;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__create_transaction;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_transaction;
+GRANT INSERT ON gl TO "lsmb_<?lsmb dbname ?>__create_transaction";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__create_transaction";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__create_transaction";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_transaction";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (73, 'allow', 'lsmb_<?lsmb dbname ?>__create_transaction');
@@ -808,22 +808,22 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (40, 'allow', 'lsmb_<?lsmb dbname ?>__create_transaction');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_transaction_voucher
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_transaction_voucher"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON gl TO lsmb_<?lsmb dbname ?>__create_transaction_voucher;
-GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__create_transaction_voucher;
-GRANT ALL ON id TO lsmb_<?lsmb dbname ?>__create_transaction_voucher;
-GRANT ALL ON acc_trans_entry_id_seq TO lsmb_<?lsmb dbname ?>__create_transaction_voucher;
+GRANT INSERT ON gl TO "lsmb_<?lsmb dbname ?>__create_transaction_voucher";
+GRANT INSERT ON acc_trans TO "lsmb_<?lsmb dbname ?>__create_transaction_voucher";
+GRANT ALL ON id TO "lsmb_<?lsmb dbname ?>__create_transaction_voucher";
+GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_transaction_voucher";
 
 -- TODO Add menu permissions
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_transactions
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_transactions"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_ar_transactions,
+IN ROLE "lsmb_<?lsmb dbname ?>__list_ar_transactions",
 lsmb_<?lsmb dbname ?>__list_ap_transactions;
 
-GRANT SELECT ON gl TO lsmb_<?lsmb dbname ?>__list_transactions;
+GRANT SELECT ON gl TO "lsmb_<?lsmb dbname ?>__list_transactions";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (73, 'allow', 'lsmb_<?lsmb dbname ?>__list_transactions');
@@ -831,10 +831,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (76, 'allow', 'lsmb_<?lsmb dbname ?>__list_transactions');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__run_yearend
+CREATE ROLE "lsmb_<?lsmb dbname ?>__run_yearend"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT, SELECT ON acc_trans TO lsmb_<?lsmb dbname ?>__run_yearend;
+GRANT INSERT, SELECT ON acc_trans TO "lsmb_<?lsmb dbname ?>__run_yearend";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__run_yearend');
@@ -842,30 +842,30 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (132, 'allow', 'lsmb_<?lsmb dbname ?>__run_yearend');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_batches
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_batches"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_transactions;
+IN ROLE "lsmb_<?lsmb dbname ?>__list_transactions";
 
-GRANT SELECT ON batch TO lsmb_<?lsmb dbname ?>__list_batches;
-GRANT SELECT ON batch_class TO lsmb_<?lsmb dbname ?>__list_batches;
-GRANT SELECT ON voucher TO lsmb_<?lsmb dbname ?>__list_batches;
+GRANT SELECT ON batch TO "lsmb_<?lsmb dbname ?>__list_batches";
+GRANT SELECT ON batch_class TO "lsmb_<?lsmb dbname ?>__list_batches";
+GRANT SELECT ON voucher TO "lsmb_<?lsmb dbname ?>__list_batches";
 
 -- TODO:  Add menu items
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_gl
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_gl"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_transaction,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_transaction",
 lsmb_<?lsmb dbname ?>__create_transaction_voucher,
 lsmb_<?lsmb dbname ?>__run_yearend,
 lsmb_<?lsmb dbname ?>__list_transactions;
 
 -- PROJECTS
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_project
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_project"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON project TO lsmb_<?lsmb dbname ?>__create_project;
-GRANT ALL ON project_id_seq TO lsmb_<?lsmb dbname ?>__create_project;
+GRANT INSERT ON project TO "lsmb_<?lsmb dbname ?>__create_project";
+GRANT ALL ON project_id_seq TO "lsmb_<?lsmb dbname ?>__create_project";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (98, 'allow', 'lsmb_<?lsmb dbname ?>__create_project');
@@ -873,10 +873,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (99, 'allow', 'lsmb_<?lsmb dbname ?>__create_project');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_project
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_project"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON project TO lsmb_<?lsmb dbname ?>__edit_project;
+GRANT UPDATE ON project TO "lsmb_<?lsmb dbname ?>__edit_project";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (98, 'allow', 'lsmb_<?lsmb dbname ?>__edit_project');
@@ -886,12 +886,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (104, 'allow', 'lsmb_<?lsmb dbname ?>__edit_project');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__add_project_timecard
+CREATE ROLE "lsmb_<?lsmb dbname ?>__add_project_timecard"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT INSERT ON jcitems TO lsmb_<?lsmb dbname ?>__add_project_timecard;
-GRANT ALL ON jcitems_id_seq TO lsmb_<?lsmb dbname ?>__add_project_timecard;
+GRANT INSERT ON jcitems TO "lsmb_<?lsmb dbname ?>__add_project_timecard";
+GRANT ALL ON jcitems_id_seq TO "lsmb_<?lsmb dbname ?>__add_project_timecard";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (98, 'allow', 'lsmb_<?lsmb dbname ?>__add_project_timecard');
@@ -902,11 +902,11 @@ values (103, 'allow', 'lsmb_<?lsmb dbname ?>__add_project_timecard');
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (106, 'allow', 'lsmb_<?lsmb dbname ?>__add_project_timecard');
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_project_timecards
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_project_timecards"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT UPDATE ON project TO lsmb_<?lsmb dbname ?>__edit_project;
+GRANT UPDATE ON project TO "lsmb_<?lsmb dbname ?>__edit_project";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (98, 'allow', 'lsmb_<?lsmb dbname ?>__edit_project');
@@ -918,18 +918,18 @@ values (106, 'allow', 'lsmb_<?lsmb dbname ?>__edit_project');
 
 
 -- ORDER GENERATION
-CREATE ROLE lsmb_<?lsmb dbname ?>__generate_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__generate_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__read_contact;
+IN ROLE "lsmb_<?lsmb dbname ?>__read_contact";
 
-GRANT SELECT, INSERT, UPDATE ON oe TO lsmb_<?lsmb dbname ?>__generate_orders;
-GRANT SELECT, INSERT, UPDATE ON orderitems TO lsmb_<?lsmb dbname ?>__generate_orders;
-GRANT ALL ON oe_id_seq TO lsmb_<?lsmb dbname ?>__generate_orders;
-GRANT ALL ON orderitems_id_seq TO lsmb_<?lsmb dbname ?>__generate_orders;
+GRANT SELECT, INSERT, UPDATE ON oe TO "lsmb_<?lsmb dbname ?>__generate_orders";
+GRANT SELECT, INSERT, UPDATE ON orderitems TO "lsmb_<?lsmb dbname ?>__generate_orders";
+GRANT ALL ON oe_id_seq TO "lsmb_<?lsmb dbname ?>__generate_orders";
+GRANT ALL ON orderitems_id_seq TO "lsmb_<?lsmb dbname ?>__generate_orders";
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__project_generate_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__project_generate_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__generate_orders;
+IN ROLE "lsmb_<?lsmb dbname ?>__generate_orders";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (98, 'allow', 'lsmb_<?lsmb dbname ?>__project_generate_orders');
@@ -939,9 +939,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (102, 'allow', 'lsmb_<?lsmb dbname ?>__project_generate_orders');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__sales_to_purchase_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__sales_to_purchase_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__generate_orders;
+IN ROLE "lsmb_<?lsmb dbname ?>__generate_orders";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__sales_to_purchase_orders');
@@ -953,9 +953,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (58, 'allow', 'lsmb_<?lsmb dbname ?>__sales_to_purchase_orders');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__consolidate_purchase_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__consolidate_purchase_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__generate_orders;
+IN ROLE "lsmb_<?lsmb dbname ?>__generate_orders";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__consolidate_purchase_orders');
@@ -965,9 +965,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (62, 'allow', 'lsmb_<?lsmb dbname ?>__consolidate_purchase_orders');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__consolidate_sales_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__consolidate_sales_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__generate_orders;
+IN ROLE "lsmb_<?lsmb dbname ?>__generate_orders";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (50, 'allow', 'lsmb_<?lsmb dbname ?>__consolidate_sales_orders');
@@ -977,17 +977,17 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (61, 'allow', 'lsmb_<?lsmb dbname ?>__consolidate_sales_orders');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__manage_orders
+CREATE ROLE "lsmb_<?lsmb dbname ?>__manage_orders"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__project_generate_orders,
+IN ROLE "lsmb_<?lsmb dbname ?>__project_generate_orders",
 lsmb_<?lsmb dbname ?>__sales_to_purchase_orders,
 lsmb_<?lsmb dbname ?>__consolidate_purchase_orders,
 lsmb_<?lsmb dbname ?>__consolidate_sales_orders;
 
 -- FINANCIAL REPORTS
-CREATE ROLE lsmb_<?lsmb dbname ?>__run_financial_reports
+CREATE ROLE "lsmb_<?lsmb dbname ?>__run_financial_reports"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_transactions;
+IN ROLE "lsmb_<?lsmb dbname ?>__list_transactions";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (109, 'allow', 'lsmb_<?lsmb dbname ?>__run_financial_reports');
@@ -1005,7 +1005,7 @@ values (113, 'allow', 'lsmb_<?lsmb dbname ?>__run_financial_reports');
 -- TO ADD WHEN THIS IS REDESIGNED
 
 -- BATCH PRINTING
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_print_jobs
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_print_jobs"
 WITH INHERIT NOLOGIN;
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
@@ -1034,13 +1034,13 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (127, 'allow', 'lsmb_<?lsmb dbname ?>__list_print_jobs');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__print_jobs
+CREATE ROLE "lsmb_<?lsmb dbname ?>__print_jobs"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_print_jobs;
+IN ROLE "lsmb_<?lsmb dbname ?>__list_print_jobs";
 
 
 -- SYSTEM SETTINGS	
-CREATE ROLE lsmb_<?lsmb dbname ?>__list_system_settings
+CREATE ROLE "lsmb_<?lsmb dbname ?>__list_system_settings"
 WITH INHERIT NOLOGIN;
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
@@ -1051,14 +1051,14 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (131, 'allow', 'lsmb_<?lsmb dbname ?>__list_system_settings');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__change_system_settings
+CREATE ROLE "lsmb_<?lsmb dbname ?>__change_system_settings"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__list_system_settings;
+IN ROLE "lsmb_<?lsmb dbname ?>__list_system_settings";
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__set_taxes
+CREATE ROLE "lsmb_<?lsmb dbname ?>__set_taxes"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT, UPDATE ON tax TO lsmb_<?lsmb dbname ?>__set_taxes;
+GRANT INSERT, UPDATE ON tax TO "lsmb_<?lsmb dbname ?>__set_taxes";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__set_taxes');
@@ -1066,11 +1066,11 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (130, 'allow', 'lsmb_<?lsmb dbname ?>__set_taxes');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_account
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_account"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON chart TO lsmb_<?lsmb dbname ?>__create_account;
-GRANT ALL ON chart_id_seq TO lsmb_<?lsmb dbname ?>__create_account;
+GRANT INSERT ON chart TO "lsmb_<?lsmb dbname ?>__create_account";
+GRANT ALL ON chart_id_seq TO "lsmb_<?lsmb dbname ?>__create_account";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__create_account');
@@ -1080,10 +1080,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (137, 'allow', 'lsmb_<?lsmb dbname ?>__create_account');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_account
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_account"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON chart TO lsmb_<?lsmb dbname ?>__edit_account;
+GRANT UPDATE ON chart TO "lsmb_<?lsmb dbname ?>__edit_account";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__edit_account');
@@ -1093,10 +1093,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (138, 'allow', 'lsmb_<?lsmb dbname ?>__edit_account');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_gifi
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_gifi"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON gifi TO lsmb_<?lsmb dbname ?>__create_gifi;
+GRANT INSERT ON gifi TO "lsmb_<?lsmb dbname ?>__create_gifi";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__create_gifi');
@@ -1106,10 +1106,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (139, 'allow', 'lsmb_<?lsmb dbname ?>__create_gifi');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_gifi
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_gifi"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON gifi TO lsmb_<?lsmb dbname ?>__edit_gifi;
+GRANT UPDATE ON gifi TO "lsmb_<?lsmb dbname ?>__edit_gifi";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__edit_account');
@@ -1119,19 +1119,19 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (140, 'allow', 'lsmb_<?lsmb dbname ?>__edit_account');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_accounts
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_accounts"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_account,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_account",
 lsmb_<?lsmb dbname ?>__set_taxes,
 lsmb_<?lsmb dbname ?>__edit_account,
 lsmb_<?lsmb dbname ?>__create_gifi,
 lsmb_<?lsmb dbname ?>__edit_gifi;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_department
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_department"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON department TO lsmb_<?lsmb dbname ?>__create_department;
-GRANT ALL ON department_id_seq TO lsmb_<?lsmb dbname ?>__create_department;
+GRANT INSERT ON department TO "lsmb_<?lsmb dbname ?>__create_department";
+GRANT ALL ON department_id_seq TO "lsmb_<?lsmb dbname ?>__create_department";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__create_department');
@@ -1141,10 +1141,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (145, 'allow', 'lsmb_<?lsmb dbname ?>__create_department');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_department
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_department"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON department TO lsmb_<?lsmb dbname ?>__edit_department;
+GRANT UPDATE ON department TO "lsmb_<?lsmb dbname ?>__edit_department";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__edit_department');
@@ -1154,16 +1154,16 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (146, 'allow', 'lsmb_<?lsmb dbname ?>__edit_department');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_department
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_department"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_department,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_department",
 lsmb_<?lsmb dbname ?>__edit_department;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_business_type
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_business_type"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON business TO lsmb_<?lsmb dbname ?>__create_business_type;
-GRANT ALL ON business_id_seq TO lsmb_<?lsmb dbname ?>__create_business_type;
+GRANT INSERT ON business TO "lsmb_<?lsmb dbname ?>__create_business_type";
+GRANT ALL ON business_id_seq TO "lsmb_<?lsmb dbname ?>__create_business_type";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__create_business_type');
@@ -1173,10 +1173,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (148, 'allow', 'lsmb_<?lsmb dbname ?>__create_business_type');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_business_type
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_business_type"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON business TO lsmb_<?lsmb dbname ?>__edit_business_type;
+GRANT UPDATE ON business TO "lsmb_<?lsmb dbname ?>__edit_business_type";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__edit_business_type');
@@ -1186,15 +1186,15 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (149, 'allow', 'lsmb_<?lsmb dbname ?>__edit_business_type');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_business_type
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_business_type"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_business_type,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_business_type",
 lsmb_<?lsmb dbname ?>__edit_business_type;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_sic
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_sic"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON sic TO lsmb_<?lsmb dbname ?>__create_sic;
+GRANT INSERT ON sic TO "lsmb_<?lsmb dbname ?>__create_sic";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__create_sic');
@@ -1204,10 +1204,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (154, 'allow', 'lsmb_<?lsmb dbname ?>__create_sic');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_sic
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_sic"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON sic TO lsmb_<?lsmb dbname ?>__edit_sic;
+GRANT UPDATE ON sic TO "lsmb_<?lsmb dbname ?>__edit_sic";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__edit_sic');
@@ -1217,12 +1217,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (155, 'allow', 'lsmb_<?lsmb dbname ?>__edit_sic');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_sic
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_sic"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_sic,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_sic",
 lsmb_<?lsmb dbname ?>__edit_sic;
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_template
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_template"
 WITH INHERIT NOLOGIN;
 
 -- TODO Add db permissions as templates get moved into db.
@@ -1299,9 +1299,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (189, 'allow', 'lsmb_<?lsmb dbname ?>__edit_template');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__manage_system
+CREATE ROLE "lsmb_<?lsmb dbname ?>__manage_system"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__change_system_settings,
+IN ROLE "lsmb_<?lsmb dbname ?>__change_system_settings",
 lsmb_<?lsmb dbname ?>__all_accounts,
 lsmb_<?lsmb dbname ?>__all_department,
 lsmb_<?lsmb dbname ?>__all_business_type,
@@ -1309,10 +1309,10 @@ lsmb_<?lsmb dbname ?>__all_sic,
 lsmb_<?lsmb dbname ?>__edit_template;
 
 -- Manual Translation
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_language
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_language"
 WITH INHERIT NOLOGIN;
 
-GRANT INSERT ON language TO lsmb_<?lsmb dbname ?>__create_language;
+GRANT INSERT ON language TO "lsmb_<?lsmb dbname ?>__create_language";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__create_language');
@@ -1322,10 +1322,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (151, 'allow', 'lsmb_<?lsmb dbname ?>__create_language');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__edit_language
+CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_language"
 WITH INHERIT NOLOGIN;
 
-GRANT UPDATE ON language TO lsmb_<?lsmb dbname ?>__edit_language;
+GRANT UPDATE ON language TO "lsmb_<?lsmb dbname ?>__edit_language";
 
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (128, 'allow', 'lsmb_<?lsmb dbname ?>__edit_language');
@@ -1335,7 +1335,7 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (152, 'allow', 'lsmb_<?lsmb dbname ?>__edit_language');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_part_translation
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_part_translation"
 WITH INHERIT NOLOGIN;
 
 -- TODO add db permissions
@@ -1350,7 +1350,7 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (97, 'allow', 'lsmb_<?lsmb dbname ?>__create_part_translation');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__create_project_translation
+CREATE ROLE "lsmb_<?lsmb dbname ?>__create_project_translation"
 WITH INHERIT NOLOGIN;
 
 -- TODO add db permissions
@@ -1363,9 +1363,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (108, 'allow', 'lsmb_<?lsmb dbname ?>__create_project_translation');
 
 
-CREATE ROLE lsmb_<?lsmb dbname ?>__all_manual_translation
+CREATE ROLE "lsmb_<?lsmb dbname ?>__all_manual_translation"
 WITH INHERIT NOLOGIN
-IN ROLE lsmb_<?lsmb dbname ?>__create_language,
+IN ROLE "lsmb_<?lsmb dbname ?>__create_language",
 lsmb_<?lsmb dbname ?>__create_part_translation,
 lsmb_<?lsmb dbname ?>__create_project_translation;
 
@@ -1397,11 +1397,11 @@ GRANT ALL ON pending_job_id_seq TO public;
 GRANT ALL ON dpt_trans TO public;
 
 -- Roles dependant on FUNCTIONS
-CREATE ROLE lsmb_<?lsmb dbname ?>__voucher_delete 
+CREATE ROLE "lsmb_<?lsmb dbname ?>__voucher_delete" 
 WITH INHERIT NOLOGIN;
 
 GRANT EXECUTE ON FUNCTION voucher__delete(int) 
-TO lsmb_<?lsmb dbname ?>__voucher_delete;
+TO "lsmb_<?lsmb dbname ?>__voucher_delete";
 
 GRANT EXECUTE ON FUNCTION batch__delete(int) 
-TO lsmb_<?lsmb dbname ?>__voucher_delete;
+TO "lsmb_<?lsmb dbname ?>__voucher_delete";