From a5d89741335272cb25d5ee236228b570e7144801 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Fri, 21 Mar 2008 21:28:39 +0000
Subject: Correcting more missing quotes on Roles.sql

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

(limited to 'sql')

diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql
index 2f4a2c8f..b46af0af 100644
--- a/sql/modules/Roles.sql
+++ b/sql/modules/Roles.sql
@@ -115,8 +115,8 @@ 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", 
-lsmb_<?lsmb dbname ?>__edit_contact,
-lsmb_<?lsmb dbname ?>__read_contact;
+"lsmb_<?lsmb dbname ?>__edit_contact",
+"lsmb_<?lsmb dbname ?>__read_contact";
 
 -- Batches and VOuchers
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_batch"
@@ -161,7 +161,7 @@ values (194, 'allow', 'lsmb_<?lsmb dbname ?>__create_ar_transaction');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
-lsmb_<?lsmb dbname ?>__create_batch;
+"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";
@@ -173,7 +173,7 @@ GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ar_transac
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ar_invoice"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
-lsmb_<?lsmb dbname ?>__create_ar_transaction;
+"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";
@@ -189,8 +189,8 @@ values (195, 'allow', 'lsmb_<?lsmb dbname ?>__create_ar_transaction');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
-lsmb_<?lsmb dbname ?>__create_batch,
-lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher;
+"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";
@@ -232,13 +232,13 @@ values (15, 'allow', 'lsmb_<?lsmb dbname ?>__list_ar_transactions');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__ar_all_vouchers"
 WITH INHERIT NOLOGIN 
 IN ROLE "lsmb_<?lsmb dbname ?>__create_ar_transaction_voucher",
-lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher;
+"lsmb_<?lsmb dbname ?>__create_ar_invoice_voucher";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__ar_all_transactions"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_ar_transaction",
-lsmb_<?lsmb dbname ?>__create_ar_invoice,
-lsmb_<?lsmb dbname ?>__list_ar_transactions;
+"lsmb_<?lsmb dbname ?>__create_ar_invoice",
+"lsmb_<?lsmb dbname ?>__list_ar_transactions";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_sales_order"
 WITH INHERIT NOLOGIN
@@ -303,11 +303,11 @@ values (71, 'allow', 'lsmb_<?lsmb dbname ?>__list_sales_quotations');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_ar"
 WITH INHERIT NOLOGIN 
 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,
-lsmb_<?lsmb dbname ?>__list_sales_orders,
-lsmb_<?lsmb dbname ?>__list_sales_quotations;
+"lsmb_<?lsmb dbname ?>__ar_all_transactions",
+"lsmb_<?lsmb dbname ?>__create_sales_order",
+"lsmb_<?lsmb dbname ?>__create_sales_quotation",
+"lsmb_<?lsmb dbname ?>__list_sales_orders",
+"lsmb_<?lsmb dbname ?>__list_sales_quotations";
 
 -- AP
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction"
@@ -329,7 +329,7 @@ values (196, 'allow', 'lsmb_<?lsmb dbname ?>__create_ap_transaction');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
-lsmb_<?lsmb dbname ?>__create_batch;
+"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";
@@ -341,7 +341,7 @@ GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_ap_transac
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_invoice"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
-lsmb_<?lsmb dbname ?>__create_ap_transaction;
+"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";
@@ -357,7 +357,7 @@ values (197, 'allow', 'lsmb_<?lsmb dbname ?>__create_ap_transaction');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__read_contact",
-lsmb_<?lsmb dbname ?>__create_batch;
+"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";
@@ -401,13 +401,13 @@ values (34, 'allow', 'lsmb_<?lsmb dbname ?>__list_ap_transactions');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__ap_all_vouchers"
 WITH INHERIT NOLOGIN 
 IN ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction_voucher",
-lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher;
+"lsmb_<?lsmb dbname ?>__create_ap_invoice_voucher";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__ap_all_transactions"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_ap_transaction",
-lsmb_<?lsmb dbname ?>__create_ap_invoice,
-lsmb_<?lsmb dbname ?>__list_ap_transactions;
+"lsmb_<?lsmb dbname ?>__create_ap_invoice",
+"lsmb_<?lsmb dbname ?>__list_ap_transactions";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_purchase_order"
 WITH INHERIT NOLOGIN
@@ -472,11 +472,11 @@ values (72, 'allow', 'lsmb_<?lsmb dbname ?>__list_purchase_rfqs');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_ap"
 WITH INHERIT NOLOGIN 
 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,
-lsmb_<?lsmb dbname ?>__list_purchase_orders,
-lsmb_<?lsmb dbname ?>__list_purchase_rfqs;
+"lsmb_<?lsmb dbname ?>__ap_all_transactions",
+"lsmb_<?lsmb dbname ?>__create_purchase_order",
+"lsmb_<?lsmb dbname ?>__create_purchase_rfq",
+"lsmb_<?lsmb dbname ?>__list_purchase_orders",
+"lsmb_<?lsmb dbname ?>__list_purchase_rfqs";
 
 -- POS
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_pos_invoice"
@@ -529,12 +529,12 @@ values (18, 'allow', 'lsmb_<?lsmb dbname ?>__list_all_open');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__pos_cashier"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_pos_invoice",
-lsmb_<?lsmb dbname ?>__close_till;
+"lsmb_<?lsmb dbname ?>__close_till";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_pos"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__pos_cashier",
-lsmb_<?lsmb dbname ?>__list_all_open;
+"lsmb_<?lsmb dbname ?>__list_all_open";
 
 -- CASH
 CREATE ROLE "lsmb_<?lsmb dbname ?>__reconcile"
@@ -569,7 +569,7 @@ values (44, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_reconcile"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__reconcile",
-lsmb_<?lsmb dbname ?>__approve_reconciliation;
+"lsmb_<?lsmb dbname ?>__approve_reconciliation";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__process_payment"
 WITH INHERIT NOLOGIN
@@ -605,8 +605,8 @@ values (47, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__cash_all"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__all_reconcile",
-lsmb_<?lsmb dbname ?>__process_payment,
-lsmb_<?lsmb dbname ?>__process_receipt;
+"lsmb_<?lsmb dbname ?>__process_payment",
+"lsmb_<?lsmb dbname ?>__process_receipt";
 
 -- Inventory Control
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_part"
@@ -779,13 +779,13 @@ values (143, 'allow', 'lsmb_<?lsmb dbname ?>__edit_warehouse');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_inventory"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_part",
-lsmb_<?lsmb dbname ?>__inventory_reports,
-lsmb_<?lsmb dbname ?>__stock_assembly,
-lsmb_<?lsmb dbname ?>__ship_inventory,
-lsmb_<?lsmb dbname ?>__receive_inventory,
-lsmb_<?lsmb dbname ?>__transfer_inventory,
-lsmb_<?lsmb dbname ?>__edit_warehouse,
-lsmb_<?lsmb dbname ?>__create_warehouse;
+"lsmb_<?lsmb dbname ?>__inventory_reports",
+"lsmb_<?lsmb dbname ?>__stock_assembly",
+"lsmb_<?lsmb dbname ?>__ship_inventory",
+"lsmb_<?lsmb dbname ?>__receive_inventory",
+"lsmb_<?lsmb dbname ?>__transfer_inventory",
+"lsmb_<?lsmb dbname ?>__edit_warehouse",
+"lsmb_<?lsmb dbname ?>__create_warehouse";
 
 -- GL 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_transaction"
@@ -821,7 +821,7 @@ GRANT ALL ON acc_trans_entry_id_seq TO "lsmb_<?lsmb dbname ?>__create_transactio
 CREATE ROLE "lsmb_<?lsmb dbname ?>__list_transactions"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__list_ar_transactions",
-lsmb_<?lsmb dbname ?>__list_ap_transactions;
+"lsmb_<?lsmb dbname ?>__list_ap_transactions";
 
 GRANT SELECT ON gl TO "lsmb_<?lsmb dbname ?>__list_transactions";
 
@@ -856,9 +856,9 @@ GRANT SELECT ON voucher TO "lsmb_<?lsmb dbname ?>__list_batches";
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_gl"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_transaction",
-lsmb_<?lsmb dbname ?>__create_transaction_voucher,
-lsmb_<?lsmb dbname ?>__run_yearend,
-lsmb_<?lsmb dbname ?>__list_transactions;
+"lsmb_<?lsmb dbname ?>__create_transaction_voucher",
+"lsmb_<?lsmb dbname ?>__run_yearend",
+"lsmb_<?lsmb dbname ?>__list_transactions";
 
 -- PROJECTS
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_project"
@@ -980,9 +980,9 @@ values (61, 'allow', 'lsmb_<?lsmb dbname ?>__consolidate_sales_orders');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__manage_orders"
 WITH INHERIT NOLOGIN
 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;
+"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"
@@ -1122,10 +1122,10 @@ values (140, 'allow', 'lsmb_<?lsmb dbname ?>__edit_account');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_accounts"
 WITH INHERIT NOLOGIN
 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;
+"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"
 WITH INHERIT NOLOGIN;
@@ -1157,7 +1157,7 @@ values (146, 'allow', 'lsmb_<?lsmb dbname ?>__edit_department');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_department"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_department",
-lsmb_<?lsmb dbname ?>__edit_department;
+"lsmb_<?lsmb dbname ?>__edit_department";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_business_type"
 WITH INHERIT NOLOGIN;
@@ -1189,7 +1189,7 @@ values (149, 'allow', 'lsmb_<?lsmb dbname ?>__edit_business_type');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_business_type"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_business_type",
-lsmb_<?lsmb dbname ?>__edit_business_type;
+"lsmb_<?lsmb dbname ?>__edit_business_type";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_sic"
 WITH INHERIT NOLOGIN;
@@ -1220,7 +1220,7 @@ values (155, 'allow', 'lsmb_<?lsmb dbname ?>__edit_sic');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_sic"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_sic",
-lsmb_<?lsmb dbname ?>__edit_sic;
+"lsmb_<?lsmb dbname ?>__edit_sic";
 
 CREATE ROLE "lsmb_<?lsmb dbname ?>__edit_template"
 WITH INHERIT NOLOGIN;
@@ -1302,11 +1302,11 @@ values (189, 'allow', 'lsmb_<?lsmb dbname ?>__edit_template');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__manage_system"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__change_system_settings",
-lsmb_<?lsmb dbname ?>__all_accounts,
-lsmb_<?lsmb dbname ?>__all_department,
-lsmb_<?lsmb dbname ?>__all_business_type,
-lsmb_<?lsmb dbname ?>__all_sic,
-lsmb_<?lsmb dbname ?>__edit_template;
+"lsmb_<?lsmb dbname ?>__all_accounts",
+"lsmb_<?lsmb dbname ?>__all_department",
+"lsmb_<?lsmb dbname ?>__all_business_type",
+"lsmb_<?lsmb dbname ?>__all_sic",
+"lsmb_<?lsmb dbname ?>__edit_template";
 
 -- Manual Translation
 CREATE ROLE "lsmb_<?lsmb dbname ?>__create_language"
@@ -1366,8 +1366,8 @@ values (108, 'allow', 'lsmb_<?lsmb dbname ?>__create_project_translation');
 CREATE ROLE "lsmb_<?lsmb dbname ?>__all_manual_translation"
 WITH INHERIT NOLOGIN
 IN ROLE "lsmb_<?lsmb dbname ?>__create_language",
-lsmb_<?lsmb dbname ?>__create_part_translation,
-lsmb_<?lsmb dbname ?>__create_project_translation;
+"lsmb_<?lsmb dbname ?>__create_part_translation",
+"lsmb_<?lsmb dbname ?>__create_project_translation";
 
 GRANT SELECT ON custom_field_catalog TO public;
 GRANT SELECT ON custom_table_catalog TO public;
-- 
cgit v1.2.3