summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/Roles.sql116
1 files changed, 58 insertions, 58 deletions
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;