diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/modules/Roles.sql | 784 |
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"; |