From 9d932f99a8ee3d65976793e6ddaf3c7317a19888 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 21 Mar 2008 21:21:06 +0000 Subject: 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 --- sql/modules/Roles.sql | 784 +++++++++++++++++++++++++------------------------- 1 file changed, 392 insertions(+), 392 deletions(-) (limited to 'sql') 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___read_contact +CREATE ROLE "lsmb___read_contact" WITH INHERIT NOLOGIN; -GRANT SELECT ON entity TO lsmb___read_contact; -GRANT SELECT ON company TO lsmb___read_contact; -GRANT SELECT ON location TO lsmb___read_contact; -GRANT SELECT ON person TO lsmb___read_contact; -GRANT SELECT ON entity_credit_account TO lsmb___read_contact; -GRANT SELECT ON company_to_contact TO lsmb___read_contact; -GRANT SELECT ON company_to_entity TO lsmb___read_contact; -GRANT SELECT ON company_to_location TO lsmb___read_contact; -GRANT SELECT ON customertax TO lsmb___read_contact; -GRANT SELECT ON contact_class TO lsmb___read_contact; -GRANT SELECT ON entity_class TO lsmb___read_contact; -GRANT SELECT ON entity_bank_account TO lsmb___read_contact; -GRANT SELECT ON entity_note TO lsmb___read_contact; -GRANT SELECT ON entity_class_to_entity TO lsmb___read_contact; -GRANT SELECT ON entity_other_name TO lsmb___read_contact; -GRANT SELECT ON location_class TO lsmb___read_contact; -GRANT SELECT ON person_to_company TO lsmb___read_contact; -GRANT SELECT ON person_to_contact TO lsmb___read_contact; -GRANT SELECT ON person_to_contact TO lsmb___read_contact; -GRANT SELECT ON person_to_location TO lsmb___read_contact; -GRANT SELECT ON person_to_location TO lsmb___read_contact; -GRANT SELECT ON company_to_location TO lsmb___read_contact; -GRANT SELECT ON vendortax TO lsmb___read_contact; +GRANT SELECT ON entity TO "lsmb___read_contact"; +GRANT SELECT ON company TO "lsmb___read_contact"; +GRANT SELECT ON location TO "lsmb___read_contact"; +GRANT SELECT ON person TO "lsmb___read_contact"; +GRANT SELECT ON entity_credit_account TO "lsmb___read_contact"; +GRANT SELECT ON company_to_contact TO "lsmb___read_contact"; +GRANT SELECT ON company_to_entity TO "lsmb___read_contact"; +GRANT SELECT ON company_to_location TO "lsmb___read_contact"; +GRANT SELECT ON customertax TO "lsmb___read_contact"; +GRANT SELECT ON contact_class TO "lsmb___read_contact"; +GRANT SELECT ON entity_class TO "lsmb___read_contact"; +GRANT SELECT ON entity_bank_account TO "lsmb___read_contact"; +GRANT SELECT ON entity_note TO "lsmb___read_contact"; +GRANT SELECT ON entity_class_to_entity TO "lsmb___read_contact"; +GRANT SELECT ON entity_other_name TO "lsmb___read_contact"; +GRANT SELECT ON location_class TO "lsmb___read_contact"; +GRANT SELECT ON person_to_company TO "lsmb___read_contact"; +GRANT SELECT ON person_to_contact TO "lsmb___read_contact"; +GRANT SELECT ON person_to_contact TO "lsmb___read_contact"; +GRANT SELECT ON person_to_location TO "lsmb___read_contact"; +GRANT SELECT ON person_to_location TO "lsmb___read_contact"; +GRANT SELECT ON company_to_location TO "lsmb___read_contact"; +GRANT SELECT ON vendortax TO "lsmb___read_contact"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (1, 'allow', 'lsmb___read_contact'); @@ -41,38 +41,38 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (33, 'allow', 'lsmb___read_contact'); -CREATE ROLE lsmb___create_contact +CREATE ROLE "lsmb___create_contact" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; - -GRANT INSERT ON entity TO lsmb___create_contact; -GRANT ALL ON entity_id_seq TO lsmb___create_contact; -GRANT INSERT ON company TO lsmb___create_contact; -GRANT ALL ON company_id_seq TO lsmb___create_contact; -GRANT INSERT ON location TO lsmb___create_contact; -GRANT ALL ON location_id_seq TO lsmb___create_contact; -GRANT INSERT ON person TO lsmb___create_contact; -GRANT ALL ON person_id_seq TO lsmb___create_contact; -GRANT INSERT ON entity_credit_account TO lsmb___create_contact; -GRANT ALL ON entity_credit_account_id_seq TO lsmb___create_contact; -GRANT INSERT ON company_to_contact TO lsmb___create_contact; -GRANT INSERT ON company_to_entity TO lsmb___create_contact; -GRANT ALL ON SEQUENCE not_id_seq TO lsmb___create_contact; -GRANT INSERT ON company_to_location TO lsmb___create_contact; -GRANT INSERT ON customertax TO lsmb___create_contact; -GRANT INSERT ON entity_bank_account TO lsmb___create_contact; -GRANT ALL ON entity_bank_account_id_seq TO lsmb___create_contact; -GRANT INSERT ON entity_note TO lsmb___create_contact; -GRANT INSERT ON entity_class_to_entity TO lsmb___create_contact; -GRANT INSERT ON entity_other_name TO lsmb___create_contact; -GRANT INSERT ON person_to_company TO lsmb___create_contact; -GRANT INSERT ON person_to_contact TO lsmb___create_contact; -GRANT INSERT ON person_to_contact TO lsmb___create_contact; -GRANT INSERT ON person_to_location TO lsmb___create_contact; -GRANT INSERT ON person_to_location TO lsmb___create_contact; -GRANT INSERT ON company_to_location TO lsmb___create_contact; -GRANT DELETE ON company_to_location TO lsmb___create_contact; -GRANT INSERT ON vendortax TO lsmb___create_contact; +IN ROLE "lsmb___read_contact"; + +GRANT INSERT ON entity TO "lsmb___create_contact"; +GRANT ALL ON entity_id_seq TO "lsmb___create_contact"; +GRANT INSERT ON company TO "lsmb___create_contact"; +GRANT ALL ON company_id_seq TO "lsmb___create_contact"; +GRANT INSERT ON location TO "lsmb___create_contact"; +GRANT ALL ON location_id_seq TO "lsmb___create_contact"; +GRANT INSERT ON person TO "lsmb___create_contact"; +GRANT ALL ON person_id_seq TO "lsmb___create_contact"; +GRANT INSERT ON entity_credit_account TO "lsmb___create_contact"; +GRANT ALL ON entity_credit_account_id_seq TO "lsmb___create_contact"; +GRANT INSERT ON company_to_contact TO "lsmb___create_contact"; +GRANT INSERT ON company_to_entity TO "lsmb___create_contact"; +GRANT ALL ON SEQUENCE not_id_seq TO "lsmb___create_contact"; +GRANT INSERT ON company_to_location TO "lsmb___create_contact"; +GRANT INSERT ON customertax TO "lsmb___create_contact"; +GRANT INSERT ON entity_bank_account TO "lsmb___create_contact"; +GRANT ALL ON entity_bank_account_id_seq TO "lsmb___create_contact"; +GRANT INSERT ON entity_note TO "lsmb___create_contact"; +GRANT INSERT ON entity_class_to_entity TO "lsmb___create_contact"; +GRANT INSERT ON entity_other_name TO "lsmb___create_contact"; +GRANT INSERT ON person_to_company TO "lsmb___create_contact"; +GRANT INSERT ON person_to_contact TO "lsmb___create_contact"; +GRANT INSERT ON person_to_contact TO "lsmb___create_contact"; +GRANT INSERT ON person_to_location TO "lsmb___create_contact"; +GRANT INSERT ON person_to_location TO "lsmb___create_contact"; +GRANT INSERT ON company_to_location TO "lsmb___create_contact"; +GRANT DELETE ON company_to_location TO "lsmb___create_contact"; +GRANT INSERT ON vendortax TO "lsmb___create_contact"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (1, 'allow', 'lsmb___create_contact'); @@ -88,68 +88,68 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (31, 'allow', 'lsmb___create_contact'); -CREATE ROLE lsmb___edit_contact +CREATE ROLE "lsmb___edit_contact" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; - -GRANT UPDATE ON entity TO lsmb___create_contact; -GRANT UPDATE ON company TO lsmb___create_contact; -GRANT UPDATE ON location TO lsmb___create_contact; -GRANT UPDATE ON person TO lsmb___create_contact; -GRANT UPDATE ON entity_credit_account TO lsmb___create_contact; -GRANT UPDATE ON company_to_contact TO lsmb___create_contact; -GRANT UPDATE ON company_to_entity TO lsmb___create_contact; -GRANT UPDATE ON company_to_location TO lsmb___create_contact; -GRANT UPDATE ON customertax TO lsmb___create_contact; -GRANT UPDATE ON entity_bank_account TO lsmb___create_contact; -GRANT UPDATE ON entity_note TO lsmb___create_contact; -GRANT UPDATE ON entity_class_to_entity TO lsmb___create_contact; -GRANT UPDATE ON entity_other_name TO lsmb___create_contact; -GRANT UPDATE ON person_to_company TO lsmb___create_contact; -GRANT UPDATE ON person_to_contact TO lsmb___create_contact; -GRANT UPDATE ON person_to_contact TO lsmb___create_contact; -GRANT UPDATE ON person_to_location TO lsmb___create_contact; -GRANT UPDATE ON person_to_location TO lsmb___create_contact; -GRANT DELETE, INSERT ON vendortax TO lsmb___create_contact; - -CREATE ROLE lsmb___contact_all_rights +IN ROLE "lsmb___read_contact"; + +GRANT UPDATE ON entity TO "lsmb___create_contact"; +GRANT UPDATE ON company TO "lsmb___create_contact"; +GRANT UPDATE ON location TO "lsmb___create_contact"; +GRANT UPDATE ON person TO "lsmb___create_contact"; +GRANT UPDATE ON entity_credit_account TO "lsmb___create_contact"; +GRANT UPDATE ON company_to_contact TO "lsmb___create_contact"; +GRANT UPDATE ON company_to_entity TO "lsmb___create_contact"; +GRANT UPDATE ON company_to_location TO "lsmb___create_contact"; +GRANT UPDATE ON customertax TO "lsmb___create_contact"; +GRANT UPDATE ON entity_bank_account TO "lsmb___create_contact"; +GRANT UPDATE ON entity_note TO "lsmb___create_contact"; +GRANT UPDATE ON entity_class_to_entity TO "lsmb___create_contact"; +GRANT UPDATE ON entity_other_name TO "lsmb___create_contact"; +GRANT UPDATE ON person_to_company TO "lsmb___create_contact"; +GRANT UPDATE ON person_to_contact TO "lsmb___create_contact"; +GRANT UPDATE ON person_to_contact TO "lsmb___create_contact"; +GRANT UPDATE ON person_to_location TO "lsmb___create_contact"; +GRANT UPDATE ON person_to_location TO "lsmb___create_contact"; +GRANT DELETE, INSERT ON vendortax TO "lsmb___create_contact"; + +CREATE ROLE "lsmb___contact_all_rights" WITH INHERIT NOLOGIN -in role lsmb___create_contact, +in role "lsmb___create_contact", lsmb___edit_contact, lsmb___read_contact; -- Batches and VOuchers -CREATE ROLE lsmb___create_batch +CREATE ROLE "lsmb___create_batch" WITH INHERIT NOLOGIN; -GRANT INSERT ON batch TO lsmb___create_batch; -GRANT ALL ON batch_id_seq TO lsmb___create_batch; -GRANT SELECT ON batch_class TO lsmb___create_batch; -GRANT INSERT ON voucher TO lsmb___create_batch; -GRANT ALL ON voucher_id_seq TO lsmb___create_contact; +GRANT INSERT ON batch TO "lsmb___create_batch"; +GRANT ALL ON batch_id_seq TO "lsmb___create_batch"; +GRANT SELECT ON batch_class TO "lsmb___create_batch"; +GRANT INSERT ON voucher TO "lsmb___create_batch"; +GRANT ALL ON voucher_id_seq TO "lsmb___create_contact"; -- TODO add Menu ACLs -CREATE ROLE lsmb___post_batches +CREATE ROLE "lsmb___post_batches" WITH INHERIT NOLOGIN; -GRANT UPDATE ON ar TO lsmb___post_batches; -GRANT UPDATE ON ap TO lsmb___post_batches; -GRANT UPDATE ON acc_trans TO lsmb___post_batches; -GRANT UPDATE ON batch TO lsmb___post_batches; -GRANT UPDATE ON gl TO lsmb___post_batches; +GRANT UPDATE ON ar TO "lsmb___post_batches"; +GRANT UPDATE ON ap TO "lsmb___post_batches"; +GRANT UPDATE ON acc_trans TO "lsmb___post_batches"; +GRANT UPDATE ON batch TO "lsmb___post_batches"; +GRANT UPDATE ON gl TO "lsmb___post_batches"; -- TODO add Menu ACLs -- AR -CREATE ROLE lsmb___create_ar_transaction +CREATE ROLE "lsmb___create_ar_transaction" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON ar TO lsmb___create_ar_transaction; -GRANT ALL ON id TO lsmb___create_ar_transaction; -GRANT INSERT ON acc_trans TO lsmb___create_ar_transaction; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___create_ar_transaction; +GRANT INSERT ON ar TO "lsmb___create_ar_transaction"; +GRANT ALL ON id TO "lsmb___create_ar_transaction"; +GRANT INSERT ON acc_trans TO "lsmb___create_ar_transaction"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___create_ar_transaction"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (1, 'allow', 'lsmb___create_ar_transaction'); @@ -158,27 +158,27 @@ values (2, 'allow', 'lsmb___create_ar_transaction'); INSERT INTO menu_acl (node_id, acl_type, role_name) values (194, 'allow', 'lsmb___create_ar_transaction'); -CREATE ROLE lsmb___create_ar_transaction_voucher +CREATE ROLE "lsmb___create_ar_transaction_voucher" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact, +IN ROLE "lsmb___read_contact", lsmb___create_batch; -GRANT INSERT ON ar TO lsmb___create_ar_transaction_voucher; -GRANT ALL ON id TO lsmb___create_ar_transaction_voucher; -GRANT INSERT ON acc_trans TO lsmb___create_ar_transaction_voucher; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___create_ar_transaction_voucher; +GRANT INSERT ON ar TO "lsmb___create_ar_transaction_voucher"; +GRANT ALL ON id TO "lsmb___create_ar_transaction_voucher"; +GRANT INSERT ON acc_trans TO "lsmb___create_ar_transaction_voucher"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___create_ar_transaction_voucher"; -- TODO add Menu ACLs -CREATE ROLE lsmb___create_ar_invoice +CREATE ROLE "lsmb___create_ar_invoice" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact, +IN ROLE "lsmb___read_contact", lsmb___create_ar_transaction; -GRANT INSERT ON invoice TO lsmb___create_ar_invoice; -GRANT ALL ON invoice_id_seq TO lsmb___create_ar_invoice; -GRANT INSERT ON inventory TO lsmb___create_ar_invoice; -GRANT ALL ON inventory_entry_id_seq TO lsmb___create_ar_invoice; +GRANT INSERT ON invoice TO "lsmb___create_ar_invoice"; +GRANT ALL ON invoice_id_seq TO "lsmb___create_ar_invoice"; +GRANT INSERT ON inventory TO "lsmb___create_ar_invoice"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___create_ar_invoice"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (3, 'allow', 'lsmb___create_ar_invoice'); @@ -186,27 +186,27 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (195, 'allow', 'lsmb___create_ar_transaction'); -CREATE ROLE lsmb___create_ar_invoice_voucher +CREATE ROLE "lsmb___create_ar_invoice_voucher" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact, +IN ROLE "lsmb___read_contact", lsmb___create_batch, lsmb___create_ar_transaction_voucher; -GRANT INSERT ON invoice TO lsmb___create_ar_invoice_voucher; -GRANT ALL ON invoice_id_seq TO lsmb___create_ar_invoice_voucher; -GRANT INSERT ON inventory TO lsmb___create_ar_invoice_voucher; -GRANT ALL ON inventory_entry_id_seq TO lsmb___create_ar_invoice_voucher; +GRANT INSERT ON invoice TO "lsmb___create_ar_invoice_voucher"; +GRANT ALL ON invoice_id_seq TO "lsmb___create_ar_invoice_voucher"; +GRANT INSERT ON inventory TO "lsmb___create_ar_invoice_voucher"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___create_ar_invoice_voucher"; -- TODO add Menu ACLs -CREATE ROLE lsmb___list_ar_transactions +CREATE ROLE "lsmb___list_ar_transactions" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT SELECT ON ar TO lsmb___list_ar_transactions; -GRANT SELECT ON acc_trans TO lsmb___list_ar_transactions; -GRANT SELECT ON invoice TO lsmb___list_ar_transactions; -GRANT SELECT ON inventory TO lsmb___list_ar_transactions; +GRANT SELECT ON ar TO "lsmb___list_ar_transactions"; +GRANT SELECT ON acc_trans TO "lsmb___list_ar_transactions"; +GRANT SELECT ON invoice TO "lsmb___list_ar_transactions"; +GRANT SELECT ON inventory TO "lsmb___list_ar_transactions"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (1, 'allow', 'lsmb___list_ar_transactions'); @@ -229,25 +229,25 @@ values (13, 'allow', 'lsmb___list_ar_transactions'); INSERT INTO menu_acl (node_id, acl_type, role_name) values (15, 'allow', 'lsmb___list_ar_transactions'); -CREATE ROLE lsmb___ar_all_vouchers +CREATE ROLE "lsmb___ar_all_vouchers" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_ar_transaction_voucher, +IN ROLE "lsmb___create_ar_transaction_voucher", lsmb___create_ar_invoice_voucher; -CREATE ROLE lsmb___ar_all_transactions +CREATE ROLE "lsmb___ar_all_transactions" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_ar_transaction, +IN ROLE "lsmb___create_ar_transaction", lsmb___create_ar_invoice, lsmb___list_ar_transactions; -CREATE ROLE lsmb___create_sales_order +CREATE ROLE "lsmb___create_sales_order" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON oe TO lsmb___create_sales_order; -GRANT ALL ON oe_id_seq TO lsmb___create_sales_order; -GRANT INSERT ON orderitems TO lsmb___create_sales_order; -GRANT ALL ON orderitems_id_seq TO lsmb___create_sales_order; +GRANT INSERT ON oe TO "lsmb___create_sales_order"; +GRANT ALL ON oe_id_seq TO "lsmb___create_sales_order"; +GRANT INSERT ON orderitems TO "lsmb___create_sales_order"; +GRANT ALL ON orderitems_id_seq TO "lsmb___create_sales_order"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (50, 'allow', 'lsmb___create_sales_order'); @@ -255,14 +255,14 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (51, 'allow', 'lsmb___create_sales_order'); -CREATE ROLE lsmb___create_sales_quotation +CREATE ROLE "lsmb___create_sales_quotation" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON oe TO lsmb___create_sales_quotation; -GRANT ALL ON oe_id_seq TO lsmb___create_sales_quotation; -GRANT INSERT ON orderitems TO lsmb___create_sales_quotation; -GRANT ALL ON orderitems_id_seq TO lsmb___create_sales_quotation; +GRANT INSERT ON oe TO "lsmb___create_sales_quotation"; +GRANT ALL ON oe_id_seq TO "lsmb___create_sales_quotation"; +GRANT INSERT ON orderitems TO "lsmb___create_sales_quotation"; +GRANT ALL ON orderitems_id_seq TO "lsmb___create_sales_quotation"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (67, 'allow', 'lsmb___create_sales_quotation'); @@ -270,12 +270,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (68, 'allow', 'lsmb___create_sales_quotation'); -CREATE ROLE lsmb___list_sales_orders +CREATE ROLE "lsmb___list_sales_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT SELECT ON oe TO lsmb___list_sales_orders; -GRANT SELECT ON orderitems TO lsmb___list_sales_orders; +GRANT SELECT ON oe TO "lsmb___list_sales_orders"; +GRANT SELECT ON orderitems TO "lsmb___list_sales_orders"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (50, 'allow', 'lsmb___list_sales_orders'); @@ -285,12 +285,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (54, 'allow', 'lsmb___list_sales_orders'); -CREATE ROLE lsmb___list_sales_quotations +CREATE ROLE "lsmb___list_sales_quotations" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT SELECT ON oe TO lsmb___list_sales_quotations; -GRANT SELECT ON orderitems TO lsmb___list_sales_quotations; +GRANT SELECT ON oe TO "lsmb___list_sales_quotations"; +GRANT SELECT ON orderitems TO "lsmb___list_sales_quotations"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (67, 'allow', 'lsmb___list_sales_quotations'); @@ -300,9 +300,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (71, 'allow', 'lsmb___list_sales_quotations'); -CREATE ROLE lsmb___all_ar +CREATE ROLE "lsmb___all_ar" WITH INHERIT NOLOGIN -IN ROLE lsmb___ar_all_vouchers, +IN ROLE "lsmb___ar_all_vouchers", lsmb___ar_all_transactions, lsmb___create_sales_order, lsmb___create_sales_quotation, @@ -310,14 +310,14 @@ lsmb___list_sales_orders, lsmb___list_sales_quotations; -- AP -CREATE ROLE lsmb___create_ap_transaction +CREATE ROLE "lsmb___create_ap_transaction" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON ap TO lsmb___create_ap_transaction; -GRANT ALL ON id TO lsmb___create_ap_transaction; -GRANT INSERT ON acc_trans TO lsmb___create_ap_transaction; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___create_ap_transaction; +GRANT INSERT ON ap TO "lsmb___create_ap_transaction"; +GRANT ALL ON id TO "lsmb___create_ap_transaction"; +GRANT INSERT ON acc_trans TO "lsmb___create_ap_transaction"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___create_ap_transaction"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (21, 'allow', 'lsmb___create_ap_transaction'); @@ -326,27 +326,27 @@ values (22, 'allow', 'lsmb___create_ap_transaction'); INSERT INTO menu_acl (node_id, acl_type, role_name) values (196, 'allow', 'lsmb___create_ap_transaction'); -CREATE ROLE lsmb___create_ap_transaction_voucher +CREATE ROLE "lsmb___create_ap_transaction_voucher" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact, +IN ROLE "lsmb___read_contact", lsmb___create_batch; -GRANT INSERT ON ar TO lsmb___create_ap_transaction_voucher; -GRANT ALL ON id TO lsmb___create_ap_transaction_voucher; -GRANT INSERT ON acc_trans TO lsmb___create_ap_transaction_voucher; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___create_ap_transaction_voucher; +GRANT INSERT ON ar TO "lsmb___create_ap_transaction_voucher"; +GRANT ALL ON id TO "lsmb___create_ap_transaction_voucher"; +GRANT INSERT ON acc_trans TO "lsmb___create_ap_transaction_voucher"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___create_ap_transaction_voucher"; -- TODO add Menu ACLs -CREATE ROLE lsmb___create_ap_invoice +CREATE ROLE "lsmb___create_ap_invoice" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact, +IN ROLE "lsmb___read_contact", lsmb___create_ap_transaction; -GRANT INSERT ON invoice TO lsmb___create_ap_invoice; -GRANT INSERT ON inventory TO lsmb___create_ap_invoice; -GRANT ALL ON invoice_id_seq TO lsmb___create_ap_invoice; -GRANT ALL ON inventory_entry_id_seq TO lsmb___create_ap_invoice; +GRANT INSERT ON invoice TO "lsmb___create_ap_invoice"; +GRANT INSERT ON inventory TO "lsmb___create_ap_invoice"; +GRANT ALL ON invoice_id_seq TO "lsmb___create_ap_invoice"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___create_ap_invoice"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (23, 'allow', 'lsmb___create_ap_invoice'); @@ -354,27 +354,27 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (197, 'allow', 'lsmb___create_ap_transaction'); -CREATE ROLE lsmb___create_ap_invoice_voucher +CREATE ROLE "lsmb___create_ap_invoice_voucher" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact, +IN ROLE "lsmb___read_contact", lsmb___create_batch; -GRANT INSERT ON invoice TO lsmb___create_ap_invoice_voucher; -GRANT INSERT ON inventory TO lsmb___create_ap_invoice_voucher; -GRANT ALL ON invoice_id_seq TO lsmb___create_ap_invoice_voucher; -GRANT ALL ON inventory_entry_id_seq TO lsmb___create_ap_invoice_voucher; +GRANT INSERT ON invoice TO "lsmb___create_ap_invoice_voucher"; +GRANT INSERT ON inventory TO "lsmb___create_ap_invoice_voucher"; +GRANT ALL ON invoice_id_seq TO "lsmb___create_ap_invoice_voucher"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___create_ap_invoice_voucher"; -- TODO add Menu ACLs -CREATE ROLE lsmb___list_ap_transactions +CREATE ROLE "lsmb___list_ap_transactions" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT SELECT ON ap TO lsmb___list_ap_transactions; -GRANT SELECT ON acc_trans TO lsmb___list_ap_transactions; -GRANT SELECT ON invoice TO lsmb___list_ap_transactions; -GRANT SELECT ON inventory TO lsmb___list_ap_transactions; +GRANT SELECT ON ap TO "lsmb___list_ap_transactions"; +GRANT SELECT ON acc_trans TO "lsmb___list_ap_transactions"; +GRANT SELECT ON invoice TO "lsmb___list_ap_transactions"; +GRANT SELECT ON inventory TO "lsmb___list_ap_transactions"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (21, 'allow', 'lsmb___list_ap_transactions'); @@ -398,25 +398,25 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (34, 'allow', 'lsmb___list_ap_transactions'); -CREATE ROLE lsmb___ap_all_vouchers +CREATE ROLE "lsmb___ap_all_vouchers" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_ap_transaction_voucher, +IN ROLE "lsmb___create_ap_transaction_voucher", lsmb___create_ap_invoice_voucher; -CREATE ROLE lsmb___ap_all_transactions +CREATE ROLE "lsmb___ap_all_transactions" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_ap_transaction, +IN ROLE "lsmb___create_ap_transaction", lsmb___create_ap_invoice, lsmb___list_ap_transactions; -CREATE ROLE lsmb___create_purchase_order +CREATE ROLE "lsmb___create_purchase_order" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON oe TO lsmb___create_purchase_order; -GRANT INSERT ON orderitems TO lsmb___create_purchase_order; -GRANT ALL ON oe_id_seq TO lsmb___create_purchase_order; -GRANT ALL ON orderitems_id_seq TO lsmb___create_purchase_order; +GRANT INSERT ON oe TO "lsmb___create_purchase_order"; +GRANT INSERT ON orderitems TO "lsmb___create_purchase_order"; +GRANT ALL ON oe_id_seq TO "lsmb___create_purchase_order"; +GRANT ALL ON orderitems_id_seq TO "lsmb___create_purchase_order"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (50, 'allow', 'lsmb___create_purchase_order'); @@ -424,14 +424,14 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (52, 'allow', 'lsmb___create_purchase_order'); -CREATE ROLE lsmb___create_purchase_rfq +CREATE ROLE "lsmb___create_purchase_rfq" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON oe TO lsmb___create_purchase_rfq; -GRANT INSERT ON orderitems TO lsmb___create_purchase_rfq; -GRANT ALL ON oe_id_seq TO lsmb___create_purchase_rfq; -GRANT ALL ON orderitems_id_seq TO lsmb___create_purchase_rfq; +GRANT INSERT ON oe TO "lsmb___create_purchase_rfq"; +GRANT INSERT ON orderitems TO "lsmb___create_purchase_rfq"; +GRANT ALL ON oe_id_seq TO "lsmb___create_purchase_rfq"; +GRANT ALL ON orderitems_id_seq TO "lsmb___create_purchase_rfq"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (67, 'allow', 'lsmb___create_purchase_rfq'); @@ -439,12 +439,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (69, 'allow', 'lsmb___create_purchase_rfq'); -CREATE ROLE lsmb___list_purchase_orders +CREATE ROLE "lsmb___list_purchase_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT SELECT ON oe TO lsmb___list_purchase_orders; -GRANT SELECT ON orderitems TO lsmb___list_purchase_orders; +GRANT SELECT ON oe TO "lsmb___list_purchase_orders"; +GRANT SELECT ON orderitems TO "lsmb___list_purchase_orders"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (50, 'allow', 'lsmb___list_purchase_orders'); @@ -454,12 +454,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (55, 'allow', 'lsmb___list_purchase_orders'); -CREATE ROLE lsmb___list_purchase_rfqs +CREATE ROLE "lsmb___list_purchase_rfqs" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT SELECT ON oe TO lsmb___list_purchase_rfqs; -GRANT SELECT ON orderitems TO lsmb___list_purchase_rfqs; +GRANT SELECT ON oe TO "lsmb___list_purchase_rfqs"; +GRANT SELECT ON orderitems TO "lsmb___list_purchase_rfqs"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (67, 'allow', 'lsmb___list_purchase_rfqs'); @@ -469,9 +469,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (72, 'allow', 'lsmb___list_purchase_rfqs'); -CREATE ROLE lsmb___all_ap +CREATE ROLE "lsmb___all_ap" WITH INHERIT NOLOGIN -IN ROLE lsmb___ap_all_vouchers, +IN ROLE "lsmb___ap_all_vouchers", lsmb___ap_all_transactions, lsmb___create_purchase_order, lsmb___create_purchase_rfq, @@ -479,18 +479,18 @@ lsmb___list_purchase_orders, lsmb___list_purchase_rfqs; -- POS -CREATE ROLE lsmb___create_pos_invoice +CREATE ROLE "lsmb___create_pos_invoice" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON invoice TO lsmb___create_pos_invoice; -GRANT INSERT ON inventory TO lsmb___create_pos_invoice; -GRANT INSERT ON ar TO lsmb___create_pos_invoice; -GRANT INSERT ON acc_trans TO lsmb___create_pos_invoice; -GRANT ALL ON id TO lsmb___create_pos_invoice; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___create_pos_invoice; -GRANT ALL ON invoice_id_seq TO lsmb___create_pos_invoice; -GRANT ALL ON inventory_entry_id_seq TO lsmb___create_pos_invoice; +GRANT INSERT ON invoice TO "lsmb___create_pos_invoice"; +GRANT INSERT ON inventory TO "lsmb___create_pos_invoice"; +GRANT INSERT ON ar TO "lsmb___create_pos_invoice"; +GRANT INSERT ON acc_trans TO "lsmb___create_pos_invoice"; +GRANT ALL ON id TO "lsmb___create_pos_invoice"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___create_pos_invoice"; +GRANT ALL ON invoice_id_seq TO "lsmb___create_pos_invoice"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___create_pos_invoice"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (16, 'allow', 'lsmb___create_pos_invoice'); @@ -500,13 +500,13 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (18, 'allow', 'lsmb___create_pos_invoice'); -CREATE ROLE lsmb___close_till +CREATE ROLE "lsmb___close_till" WITH INHERIT NOLOGIN; -GRANT INSERT ON gl TO lsmb___close_till; -GRANT INSERT ON acc_trans TO lsmb___close_till; -GRANT ALL ON id TO lsmb___close_till; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___close_till; +GRANT INSERT ON gl TO "lsmb___close_till"; +GRANT INSERT ON acc_trans TO "lsmb___close_till"; +GRANT ALL ON id TO "lsmb___close_till"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___close_till"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (16, 'allow', 'lsmb___close_till'); @@ -514,11 +514,11 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (19, 'allow', 'lsmb___close_till'); -CREATE ROLE lsmb___list_all_open +CREATE ROLE "lsmb___list_all_open" WITH INHERIT NOLOGIN; -GRANT SELECT ON ar TO lsmb___list_all_open; -GRANT SELECT ON acc_trans TO lsmb___list_all_open; +GRANT SELECT ON ar TO "lsmb___list_all_open"; +GRANT SELECT ON acc_trans TO "lsmb___list_all_open"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (16, 'allow', 'lsmb___list_all_open'); @@ -526,25 +526,25 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (18, 'allow', 'lsmb___list_all_open'); -CREATE ROLE lsmb___pos_cashier +CREATE ROLE "lsmb___pos_cashier" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_pos_invoice, +IN ROLE "lsmb___create_pos_invoice", lsmb___close_till; -CREATE ROLE lsmb___all_pos +CREATE ROLE "lsmb___all_pos" WITH INHERIT NOLOGIN -IN ROLE lsmb___pos_cashier, +IN ROLE "lsmb___pos_cashier", lsmb___list_all_open; -- CASH -CREATE ROLE lsmb___reconcile +CREATE ROLE "lsmb___reconcile" WITH INHERIT NOLOGIN; --- GRANT INSERT ON pending_reports TO lsmb___reconcile; --- GRANT INSERT on report_corrections TO lsmb___reconcile; -GRANT SELECT ON acc_trans TO lsmb___reconcile; --- GRANT ALL ON pending_reports_id_seq TO lsmb___reconcile; --- GRANT ALL ON report_corrections_id_seq TO lsmb___reconcile; +-- GRANT INSERT ON pending_reports TO "lsmb___reconcile"; +-- GRANT INSERT on report_corrections TO "lsmb___reconcile"; +GRANT SELECT ON acc_trans TO "lsmb___reconcile"; +-- GRANT ALL ON pending_reports_id_seq TO "lsmb___reconcile"; +-- GRANT ALL ON report_corrections_id_seq TO "lsmb___reconcile"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (35, 'allow', 'lsmb__reconcile'); @@ -552,11 +552,11 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (45, 'allow', 'lsmb__reconcile'); -CREATE ROLE lsmb___approve_reconciliation +CREATE ROLE "lsmb___approve_reconciliation" WITH INHERIT NOLOGIN; --- GRANT UPDATE ON pending_reports TO lsmb___reconcile; -GRANT SELECT ON acc_trans TO lsmb___reconcile; +-- GRANT UPDATE ON pending_reports TO "lsmb___reconcile"; +GRANT SELECT ON acc_trans TO "lsmb___reconcile"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (35, 'allow', 'lsmb__reconcile'); @@ -566,17 +566,17 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (44, 'allow', 'lsmb__reconcile'); -CREATE ROLE lsmb___all_reconcile +CREATE ROLE "lsmb___all_reconcile" WITH INHERIT NOLOGIN -IN ROLE lsmb___reconcile, +IN ROLE "lsmb___reconcile", lsmb___approve_reconciliation; -CREATE ROLE lsmb___process_payment +CREATE ROLE "lsmb___process_payment" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_ap_transactions; +IN ROLE "lsmb___list_ap_transactions"; -GRANT INSERT ON acc_trans TO lsmb___process_payment; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___process_payment; +GRANT INSERT ON acc_trans TO "lsmb___process_payment"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___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___process_payment'); -CREATE ROLE lsmb___process_receipt +CREATE ROLE "lsmb___process_receipt" WITH INHERIT NOLOGIN -IN ROLE lsmb___ar_list_transactions; +IN ROLE "lsmb___ar_list_transactions"; -GRANT INSERT ON acc_trans TO lsmb___process_receipt; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___process_receipt; +GRANT INSERT ON acc_trans TO "lsmb___process_receipt"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___process_receipt"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (35, 'allow', 'lsmb___process_receipt'); @@ -602,18 +602,18 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (47, 'allow', 'lsmb___process_receipt'); -CREATE ROLE lsmb___cash_all +CREATE ROLE "lsmb___cash_all" WITH INHERIT NOLOGIN -IN ROLE lsmb___all_reconcile, +IN ROLE "lsmb___all_reconcile", lsmb___process_payment, lsmb___process_receipt; -- Inventory Control -CREATE ROLE lsmb___create_part +CREATE ROLE "lsmb___create_part" WITH INHERIT NOLOGIN; -GRANT INSERT ON parts TO lsmb___create_part; -GRANT ALL ON parts_id_seq TO lsmb___create_part; +GRANT INSERT ON parts TO "lsmb___create_part"; +GRANT ALL ON parts_id_seq TO "lsmb___create_part"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (77, 'allow', 'lsmb___create_part'); @@ -629,10 +629,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (82, 'allow', 'lsmb___create_part'); -CREATE ROLE lsmb___edit_part +CREATE ROLE "lsmb___edit_part" WITH INHERIT NOLOGIN; -GRANT UPDATE ON parts TO lsmb___edit_part; +GRANT UPDATE ON parts TO "lsmb___edit_part"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (77, 'allow', 'lsmb___edit_part'); @@ -654,14 +654,14 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (93, 'allow', 'lsmb___edit_part'); -CREATE ROLE lsmb___inventory_reports +CREATE ROLE "lsmb___inventory_reports" WITH INHERIT NOLOGIN; -GRANT SELECT ON ar TO lsmb___inventory_reports; -GRANT SELECT ON ap TO lsmb___inventory_reports; -GRANT SELECT ON inventory TO lsmb___inventory_reports; -GRANT SELECT ON invoice TO lsmb___inventory_reports; -GRANT SELECT ON acc_trans TO lsmb___inventory_reports; +GRANT SELECT ON ar TO "lsmb___inventory_reports"; +GRANT SELECT ON ap TO "lsmb___inventory_reports"; +GRANT SELECT ON inventory TO "lsmb___inventory_reports"; +GRANT SELECT ON invoice TO "lsmb___inventory_reports"; +GRANT SELECT ON acc_trans TO "lsmb___inventory_reports"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (77, 'allow', 'lsmb___inventory_reports'); @@ -673,13 +673,13 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (94, 'allow', 'lsmb___inventory_reports'); -CREATE ROLE lsmb___create_pricegroup +CREATE ROLE "lsmb___create_pricegroup" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON pricegroup TO lsmb___create_pricegroup; -GRANT ALL ON pricegroup_id_seq TO lsmb___create_pricegroup; -GRANT UPDATE ON entity_credit_account TO lsmb___create_pricegroup; +GRANT INSERT ON pricegroup TO "lsmb___create_pricegroup"; +GRANT ALL ON pricegroup_id_seq TO "lsmb___create_pricegroup"; +GRANT UPDATE ON entity_credit_account TO "lsmb___create_pricegroup"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (77, 'allow', 'lsmb___create_pricegroup'); @@ -687,12 +687,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (83, 'allow', 'lsmb___create_pricegroup'); -CREATE ROLE lsmb___edit_pricegroup +CREATE ROLE "lsmb___edit_pricegroup" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT UPDATE ON pricegroup TO lsmb___edit_pricegroup; -GRANT UPDATE ON entity_credit_account TO lsmb___edit_pricegroup; +GRANT UPDATE ON pricegroup TO "lsmb___edit_pricegroup"; +GRANT UPDATE ON entity_credit_account TO "lsmb___edit_pricegroup"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (77, 'allow', 'lsmb___edit_pricegroup'); @@ -701,10 +701,10 @@ values (85, 'allow', 'lsmb___edit_pricegroup'); INSERT INTO menu_acl (node_id, acl_type, role_name) values (92, 'allow', 'lsmb___edit_pricegroup'); -CREATE ROLE lsmb___stock_assembly +CREATE ROLE "lsmb___stock_assembly" WITH INHERIT NOLOGIN; -GRANT UPDATE ON parts TO lsmb___stock_assembly; +GRANT UPDATE ON parts TO "lsmb___stock_assembly"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (77, 'allow', 'lsmb___stock_assembly'); @@ -712,12 +712,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (84, 'allow', 'lsmb___stock_assembly'); -CREATE ROLE lsmb___ship_inventory +CREATE ROLE "lsmb___ship_inventory" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_sales_orders; +IN ROLE "lsmb___list_sales_orders"; -GRANT INSERT ON inventory TO lsmb___ship_inventory; -GRANT ALL ON inventory_entry_id_seq TO lsmb___ship_inventory; +GRANT INSERT ON inventory TO "lsmb___ship_inventory"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___ship_inventory"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (63, 'allow', 'lsmb___ship_inventory'); @@ -725,12 +725,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (64, 'allow', 'lsmb___ship_inventory'); -CREATE ROLE lsmb___receive_inventory +CREATE ROLE "lsmb___receive_inventory" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_purchase_orders; +IN ROLE "lsmb___list_purchase_orders"; -GRANT INSERT ON inventory TO lsmb___receive_inventory; -GRANT ALL ON inventory_entry_id_seq TO lsmb___receive_inventory; +GRANT INSERT ON inventory TO "lsmb___receive_inventory"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___receive_inventory"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (63, 'allow', 'lsmb___receive_inventory'); @@ -738,22 +738,22 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (65, 'allow', 'lsmb___receive_inventory'); -CREATE ROLE lsmb___transfer_inventory +CREATE ROLE "lsmb___transfer_inventory" WITH INHERIT NOLOGIN; -GRANT INSERT ON inventory TO lsmb___transfer_inventory; -GRANT ALL ON inventory_entry_id_seq TO lsmb___transfer_inventory; +GRANT INSERT ON inventory TO "lsmb___transfer_inventory"; +GRANT ALL ON inventory_entry_id_seq TO "lsmb___transfer_inventory"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (63, 'allow', 'lsmb___transfer_inventory'); INSERT INTO menu_acl (node_id, acl_type, role_name) values (66, 'allow', 'lsmb___transfer_inventory'); -CREATE ROLE lsmb___create_warehouse +CREATE ROLE "lsmb___create_warehouse" WITH INHERIT NOLOGIN; -GRANT INSERT ON warehouse TO lsmb___create_warehouse; -GRANT ALL ON warehouse_id_seq TO lsmb___create_warehouse; +GRANT INSERT ON warehouse TO "lsmb___create_warehouse"; +GRANT ALL ON warehouse_id_seq TO "lsmb___create_warehouse"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___create_warehouse'); @@ -763,10 +763,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (142, 'allow', 'lsmb___create_warehouse'); -CREATE ROLE lsmb___edit_warehouse +CREATE ROLE "lsmb___edit_warehouse" WITH INHERIT NOLOGIN; -GRANT UPDATE ON warehouse TO lsmb___edit_warehouse; +GRANT UPDATE ON warehouse TO "lsmb___edit_warehouse"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___edit_warehouse'); @@ -776,9 +776,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (143, 'allow', 'lsmb___edit_warehouse'); -CREATE ROLE lsmb___all_inventory +CREATE ROLE "lsmb___all_inventory" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_part, +IN ROLE "lsmb___create_part", lsmb___inventory_reports, lsmb___stock_assembly, lsmb___ship_inventory, @@ -788,13 +788,13 @@ lsmb___edit_warehouse, lsmb___create_warehouse; -- GL -CREATE ROLE lsmb___create_transaction +CREATE ROLE "lsmb___create_transaction" WITH INHERIT NOLOGIN; -GRANT INSERT ON gl TO lsmb___create_transaction; -GRANT INSERT ON acc_trans TO lsmb___create_transaction; -GRANT ALL ON id TO lsmb___create_transaction; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___create_transaction; +GRANT INSERT ON gl TO "lsmb___create_transaction"; +GRANT INSERT ON acc_trans TO "lsmb___create_transaction"; +GRANT ALL ON id TO "lsmb___create_transaction"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___create_transaction"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (73, 'allow', 'lsmb___create_transaction'); @@ -808,22 +808,22 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (40, 'allow', 'lsmb___create_transaction'); -CREATE ROLE lsmb___create_transaction_voucher +CREATE ROLE "lsmb___create_transaction_voucher" WITH INHERIT NOLOGIN; -GRANT INSERT ON gl TO lsmb___create_transaction_voucher; -GRANT INSERT ON acc_trans TO lsmb___create_transaction_voucher; -GRANT ALL ON id TO lsmb___create_transaction_voucher; -GRANT ALL ON acc_trans_entry_id_seq TO lsmb___create_transaction_voucher; +GRANT INSERT ON gl TO "lsmb___create_transaction_voucher"; +GRANT INSERT ON acc_trans TO "lsmb___create_transaction_voucher"; +GRANT ALL ON id TO "lsmb___create_transaction_voucher"; +GRANT ALL ON acc_trans_entry_id_seq TO "lsmb___create_transaction_voucher"; -- TODO Add menu permissions -CREATE ROLE lsmb___list_transactions +CREATE ROLE "lsmb___list_transactions" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_ar_transactions, +IN ROLE "lsmb___list_ar_transactions", lsmb___list_ap_transactions; -GRANT SELECT ON gl TO lsmb___list_transactions; +GRANT SELECT ON gl TO "lsmb___list_transactions"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (73, 'allow', 'lsmb___list_transactions'); @@ -831,10 +831,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (76, 'allow', 'lsmb___list_transactions'); -CREATE ROLE lsmb___run_yearend +CREATE ROLE "lsmb___run_yearend" WITH INHERIT NOLOGIN; -GRANT INSERT, SELECT ON acc_trans TO lsmb___run_yearend; +GRANT INSERT, SELECT ON acc_trans TO "lsmb___run_yearend"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___run_yearend'); @@ -842,30 +842,30 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (132, 'allow', 'lsmb___run_yearend'); -CREATE ROLE lsmb___list_batches +CREATE ROLE "lsmb___list_batches" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_transactions; +IN ROLE "lsmb___list_transactions"; -GRANT SELECT ON batch TO lsmb___list_batches; -GRANT SELECT ON batch_class TO lsmb___list_batches; -GRANT SELECT ON voucher TO lsmb___list_batches; +GRANT SELECT ON batch TO "lsmb___list_batches"; +GRANT SELECT ON batch_class TO "lsmb___list_batches"; +GRANT SELECT ON voucher TO "lsmb___list_batches"; -- TODO: Add menu items -CREATE ROLE lsmb___all_gl +CREATE ROLE "lsmb___all_gl" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_transaction, +IN ROLE "lsmb___create_transaction", lsmb___create_transaction_voucher, lsmb___run_yearend, lsmb___list_transactions; -- PROJECTS -CREATE ROLE lsmb___create_project +CREATE ROLE "lsmb___create_project" WITH INHERIT NOLOGIN; -GRANT INSERT ON project TO lsmb___create_project; -GRANT ALL ON project_id_seq TO lsmb___create_project; +GRANT INSERT ON project TO "lsmb___create_project"; +GRANT ALL ON project_id_seq TO "lsmb___create_project"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (98, 'allow', 'lsmb___create_project'); @@ -873,10 +873,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (99, 'allow', 'lsmb___create_project'); -CREATE ROLE lsmb___edit_project +CREATE ROLE "lsmb___edit_project" WITH INHERIT NOLOGIN; -GRANT UPDATE ON project TO lsmb___edit_project; +GRANT UPDATE ON project TO "lsmb___edit_project"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (98, 'allow', 'lsmb___edit_project'); @@ -886,12 +886,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (104, 'allow', 'lsmb___edit_project'); -CREATE ROLE lsmb___add_project_timecard +CREATE ROLE "lsmb___add_project_timecard" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT INSERT ON jcitems TO lsmb___add_project_timecard; -GRANT ALL ON jcitems_id_seq TO lsmb___add_project_timecard; +GRANT INSERT ON jcitems TO "lsmb___add_project_timecard"; +GRANT ALL ON jcitems_id_seq TO "lsmb___add_project_timecard"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (98, 'allow', 'lsmb___add_project_timecard'); @@ -902,11 +902,11 @@ values (103, 'allow', 'lsmb___add_project_timecard'); INSERT INTO menu_acl (node_id, acl_type, role_name) values (106, 'allow', 'lsmb___add_project_timecard'); -CREATE ROLE lsmb___list_project_timecards +CREATE ROLE "lsmb___list_project_timecards" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT UPDATE ON project TO lsmb___edit_project; +GRANT UPDATE ON project TO "lsmb___edit_project"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (98, 'allow', 'lsmb___edit_project'); @@ -918,18 +918,18 @@ values (106, 'allow', 'lsmb___edit_project'); -- ORDER GENERATION -CREATE ROLE lsmb___generate_orders +CREATE ROLE "lsmb___generate_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___read_contact; +IN ROLE "lsmb___read_contact"; -GRANT SELECT, INSERT, UPDATE ON oe TO lsmb___generate_orders; -GRANT SELECT, INSERT, UPDATE ON orderitems TO lsmb___generate_orders; -GRANT ALL ON oe_id_seq TO lsmb___generate_orders; -GRANT ALL ON orderitems_id_seq TO lsmb___generate_orders; +GRANT SELECT, INSERT, UPDATE ON oe TO "lsmb___generate_orders"; +GRANT SELECT, INSERT, UPDATE ON orderitems TO "lsmb___generate_orders"; +GRANT ALL ON oe_id_seq TO "lsmb___generate_orders"; +GRANT ALL ON orderitems_id_seq TO "lsmb___generate_orders"; -CREATE ROLE lsmb___project_generate_orders +CREATE ROLE "lsmb___project_generate_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___generate_orders; +IN ROLE "lsmb___generate_orders"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (98, 'allow', 'lsmb___project_generate_orders'); @@ -939,9 +939,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (102, 'allow', 'lsmb___project_generate_orders'); -CREATE ROLE lsmb___sales_to_purchase_orders +CREATE ROLE "lsmb___sales_to_purchase_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___generate_orders; +IN ROLE "lsmb___generate_orders"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (50, 'allow', 'lsmb___sales_to_purchase_orders'); @@ -953,9 +953,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (58, 'allow', 'lsmb___sales_to_purchase_orders'); -CREATE ROLE lsmb___consolidate_purchase_orders +CREATE ROLE "lsmb___consolidate_purchase_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___generate_orders; +IN ROLE "lsmb___generate_orders"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (50, 'allow', 'lsmb___consolidate_purchase_orders'); @@ -965,9 +965,9 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (62, 'allow', 'lsmb___consolidate_purchase_orders'); -CREATE ROLE lsmb___consolidate_sales_orders +CREATE ROLE "lsmb___consolidate_sales_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___generate_orders; +IN ROLE "lsmb___generate_orders"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (50, 'allow', 'lsmb___consolidate_sales_orders'); @@ -977,17 +977,17 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (61, 'allow', 'lsmb___consolidate_sales_orders'); -CREATE ROLE lsmb___manage_orders +CREATE ROLE "lsmb___manage_orders" WITH INHERIT NOLOGIN -IN ROLE lsmb___project_generate_orders, +IN ROLE "lsmb___project_generate_orders", lsmb___sales_to_purchase_orders, lsmb___consolidate_purchase_orders, lsmb___consolidate_sales_orders; -- FINANCIAL REPORTS -CREATE ROLE lsmb___run_financial_reports +CREATE ROLE "lsmb___run_financial_reports" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_transactions; +IN ROLE "lsmb___list_transactions"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (109, 'allow', 'lsmb___run_financial_reports'); @@ -1005,7 +1005,7 @@ values (113, 'allow', 'lsmb___run_financial_reports'); -- TO ADD WHEN THIS IS REDESIGNED -- BATCH PRINTING -CREATE ROLE lsmb___list_print_jobs +CREATE ROLE "lsmb___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___list_print_jobs'); -CREATE ROLE lsmb___print_jobs +CREATE ROLE "lsmb___print_jobs" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_print_jobs; +IN ROLE "lsmb___list_print_jobs"; -- SYSTEM SETTINGS -CREATE ROLE lsmb___list_system_settings +CREATE ROLE "lsmb___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___list_system_settings'); -CREATE ROLE lsmb___change_system_settings +CREATE ROLE "lsmb___change_system_settings" WITH INHERIT NOLOGIN -IN ROLE lsmb___list_system_settings; +IN ROLE "lsmb___list_system_settings"; -CREATE ROLE lsmb___set_taxes +CREATE ROLE "lsmb___set_taxes" WITH INHERIT NOLOGIN; -GRANT INSERT, UPDATE ON tax TO lsmb___set_taxes; +GRANT INSERT, UPDATE ON tax TO "lsmb___set_taxes"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___set_taxes'); @@ -1066,11 +1066,11 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (130, 'allow', 'lsmb___set_taxes'); -CREATE ROLE lsmb___create_account +CREATE ROLE "lsmb___create_account" WITH INHERIT NOLOGIN; -GRANT INSERT ON chart TO lsmb___create_account; -GRANT ALL ON chart_id_seq TO lsmb___create_account; +GRANT INSERT ON chart TO "lsmb___create_account"; +GRANT ALL ON chart_id_seq TO "lsmb___create_account"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___create_account'); @@ -1080,10 +1080,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (137, 'allow', 'lsmb___create_account'); -CREATE ROLE lsmb___edit_account +CREATE ROLE "lsmb___edit_account" WITH INHERIT NOLOGIN; -GRANT UPDATE ON chart TO lsmb___edit_account; +GRANT UPDATE ON chart TO "lsmb___edit_account"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___edit_account'); @@ -1093,10 +1093,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (138, 'allow', 'lsmb___edit_account'); -CREATE ROLE lsmb___create_gifi +CREATE ROLE "lsmb___create_gifi" WITH INHERIT NOLOGIN; -GRANT INSERT ON gifi TO lsmb___create_gifi; +GRANT INSERT ON gifi TO "lsmb___create_gifi"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___create_gifi'); @@ -1106,10 +1106,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (139, 'allow', 'lsmb___create_gifi'); -CREATE ROLE lsmb___edit_gifi +CREATE ROLE "lsmb___edit_gifi" WITH INHERIT NOLOGIN; -GRANT UPDATE ON gifi TO lsmb___edit_gifi; +GRANT UPDATE ON gifi TO "lsmb___edit_gifi"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___edit_account'); @@ -1119,19 +1119,19 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (140, 'allow', 'lsmb___edit_account'); -CREATE ROLE lsmb___all_accounts +CREATE ROLE "lsmb___all_accounts" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_account, +IN ROLE "lsmb___create_account", lsmb___set_taxes, lsmb___edit_account, lsmb___create_gifi, lsmb___edit_gifi; -CREATE ROLE lsmb___create_department +CREATE ROLE "lsmb___create_department" WITH INHERIT NOLOGIN; -GRANT INSERT ON department TO lsmb___create_department; -GRANT ALL ON department_id_seq TO lsmb___create_department; +GRANT INSERT ON department TO "lsmb___create_department"; +GRANT ALL ON department_id_seq TO "lsmb___create_department"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___create_department'); @@ -1141,10 +1141,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (145, 'allow', 'lsmb___create_department'); -CREATE ROLE lsmb___edit_department +CREATE ROLE "lsmb___edit_department" WITH INHERIT NOLOGIN; -GRANT UPDATE ON department TO lsmb___edit_department; +GRANT UPDATE ON department TO "lsmb___edit_department"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___edit_department'); @@ -1154,16 +1154,16 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (146, 'allow', 'lsmb___edit_department'); -CREATE ROLE lsmb___all_department +CREATE ROLE "lsmb___all_department" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_department, +IN ROLE "lsmb___create_department", lsmb___edit_department; -CREATE ROLE lsmb___create_business_type +CREATE ROLE "lsmb___create_business_type" WITH INHERIT NOLOGIN; -GRANT INSERT ON business TO lsmb___create_business_type; -GRANT ALL ON business_id_seq TO lsmb___create_business_type; +GRANT INSERT ON business TO "lsmb___create_business_type"; +GRANT ALL ON business_id_seq TO "lsmb___create_business_type"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___create_business_type'); @@ -1173,10 +1173,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (148, 'allow', 'lsmb___create_business_type'); -CREATE ROLE lsmb___edit_business_type +CREATE ROLE "lsmb___edit_business_type" WITH INHERIT NOLOGIN; -GRANT UPDATE ON business TO lsmb___edit_business_type; +GRANT UPDATE ON business TO "lsmb___edit_business_type"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___edit_business_type'); @@ -1186,15 +1186,15 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (149, 'allow', 'lsmb___edit_business_type'); -CREATE ROLE lsmb___all_business_type +CREATE ROLE "lsmb___all_business_type" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_business_type, +IN ROLE "lsmb___create_business_type", lsmb___edit_business_type; -CREATE ROLE lsmb___create_sic +CREATE ROLE "lsmb___create_sic" WITH INHERIT NOLOGIN; -GRANT INSERT ON sic TO lsmb___create_sic; +GRANT INSERT ON sic TO "lsmb___create_sic"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___create_sic'); @@ -1204,10 +1204,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (154, 'allow', 'lsmb___create_sic'); -CREATE ROLE lsmb___edit_sic +CREATE ROLE "lsmb___edit_sic" WITH INHERIT NOLOGIN; -GRANT UPDATE ON sic TO lsmb___edit_sic; +GRANT UPDATE ON sic TO "lsmb___edit_sic"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___edit_sic'); @@ -1217,12 +1217,12 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (155, 'allow', 'lsmb___edit_sic'); -CREATE ROLE lsmb___all_sic +CREATE ROLE "lsmb___all_sic" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_sic, +IN ROLE "lsmb___create_sic", lsmb___edit_sic; -CREATE ROLE lsmb___edit_template +CREATE ROLE "lsmb___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___edit_template'); -CREATE ROLE lsmb___manage_system +CREATE ROLE "lsmb___manage_system" WITH INHERIT NOLOGIN -IN ROLE lsmb___change_system_settings, +IN ROLE "lsmb___change_system_settings", lsmb___all_accounts, lsmb___all_department, lsmb___all_business_type, @@ -1309,10 +1309,10 @@ lsmb___all_sic, lsmb___edit_template; -- Manual Translation -CREATE ROLE lsmb___create_language +CREATE ROLE "lsmb___create_language" WITH INHERIT NOLOGIN; -GRANT INSERT ON language TO lsmb___create_language; +GRANT INSERT ON language TO "lsmb___create_language"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___create_language'); @@ -1322,10 +1322,10 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (151, 'allow', 'lsmb___create_language'); -CREATE ROLE lsmb___edit_language +CREATE ROLE "lsmb___edit_language" WITH INHERIT NOLOGIN; -GRANT UPDATE ON language TO lsmb___edit_language; +GRANT UPDATE ON language TO "lsmb___edit_language"; INSERT INTO menu_acl (node_id, acl_type, role_name) values (128, 'allow', 'lsmb___edit_language'); @@ -1335,7 +1335,7 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (152, 'allow', 'lsmb___edit_language'); -CREATE ROLE lsmb___create_part_translation +CREATE ROLE "lsmb___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___create_part_translation'); -CREATE ROLE lsmb___create_project_translation +CREATE ROLE "lsmb___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___create_project_translation'); -CREATE ROLE lsmb___all_manual_translation +CREATE ROLE "lsmb___all_manual_translation" WITH INHERIT NOLOGIN -IN ROLE lsmb___create_language, +IN ROLE "lsmb___create_language", lsmb___create_part_translation, lsmb___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___voucher_delete +CREATE ROLE "lsmb___voucher_delete" WITH INHERIT NOLOGIN; GRANT EXECUTE ON FUNCTION voucher__delete(int) -TO lsmb___voucher_delete; +TO "lsmb___voucher_delete"; GRANT EXECUTE ON FUNCTION batch__delete(int) -TO lsmb___voucher_delete; +TO "lsmb___voucher_delete"; -- cgit v1.2.3