diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/modules/Roles.sql | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql index 168ea927..e8ae3bb4 100644 --- a/sql/modules/Roles.sql +++ b/sql/modules/Roles.sql @@ -583,13 +583,11 @@ INSERT INTO menu_acl (node_id, acl_type, role_name) values (35, 'allow', 'lsmb_<?lsmb dbname ?>__process_payment'); INSERT INTO menu_acl (node_id, acl_type, role_name) values (38, 'allow', 'lsmb_<?lsmb dbname ?>__process_payment'); -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" WITH INHERIT NOLOGIN -IN ROLE "lsmb_<?lsmb dbname ?>__ar_list_transactions"; +IN ROLE "lsmb_<?lsmb dbname ?>__list_ar_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"; |