From a28552772e6d6cf1aaea59f4a7bd865890896431 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 12 Sep 2007 05:18:40 +0000 Subject: Correcting validation issues in frameset git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1572 4979c152-3d1c-0410-bac9-87ea11338e46 --- UI/frameset.html | 4 +-- sql/modules/Roles.sql | 72 +++++++++++++++++++++++++++++++++++++++++++++++++-- 2 files changed, 72 insertions(+), 4 deletions(-) diff --git a/UI/frameset.html b/UI/frameset.html index dadbc93a..c67753fc 100644 --- a/UI/frameset.html +++ b/UI/frameset.html @@ -1,5 +1,5 @@ - + <?lsmb title ?> diff --git a/sql/modules/Roles.sql b/sql/modules/Roles.sql index c1a8a483..f61568e8 100644 --- a/sql/modules/Roles.sql +++ b/sql/modules/Roles.sql @@ -481,6 +481,15 @@ values (19, 'allow', 'lsmb___close_till'); 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; + +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (16, 'allow', 'lsmb___list_all_open'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (18, 'allow', 'lsmb___list_all_open'); + + CREATE ROLE lsmb___pos_cashier WITH INHERIT NOLOGIN lsmb___create_pos_invoice, @@ -495,9 +504,30 @@ lsmb___list_all_open; 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; + +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (35, 'allow', 'lsmb__reconcile'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (45, 'allow', 'lsmb__reconcile'); + + CREATE ROLE lsmb___approve_reconciliation WITH INHERIT NOLOGIN; +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'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (41, 'allow', 'lsmb__reconcile'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (44, 'allow', 'lsmb__reconcile'); + + CREATE ROLE lsmb___all_reconcile WITH INHERIT NOLOGIN IN ROLE lsmb___reconcile, @@ -505,11 +535,31 @@ lsmb___approve_reconciliation; CREATE ROLE lsmb___process_payment WITH INHERIT NOLOGIN -IN ROLE ar_list_transactions; +IN ROLE ap_list_transactions; + +GRANT INSERT ON acc_trans TO lsmb___process_payment; + +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (35, 'allow', 'lsmb___process_payment'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (38, 'allow', 'lsmb___process_payment'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (39, 'allow', 'lsmb___process_payment'); + CREATE ROLE lsmb___process_receipt WITH INHERIT NOLOGIN -IN ROLE ap_list_transactions; +IN ROLE ar_list_transactions; + +GRANT INSERT ON acc_trans TO lsmb___process_receipt; + +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (35, 'allow', 'lsmb___process_receipt'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (36, 'allow', 'lsmb___process_receipt'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (47, 'allow', 'lsmb___process_receipt'); + CREATE ROLE lsmb___cash_all WITH INHERIT NOLOGIN @@ -521,6 +571,24 @@ lsmb___process_receipt; CREATE ROLE lsmb___create_part WITH INHERIT NOLOGIN; +GRANT INSERT ON parts TO lsmb___create_part; + +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (77, 'allow', 'lsmb___create_part'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (78, 'allow', 'lsmb___create_part'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (79, 'allow', 'lsmb___create_part'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (80, 'allow', 'lsmb___create_part'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (81, 'allow', 'lsmb___create_part'); +INSERT INTO menu_acl (node_id, acl_type, role_name) +values (82, 'allow', 'lsmb___create_part'); + +CREATE ROLE lsmb___edit_part +WITH INHERIT NOLOGIN; + CREATE ROLE lsmb___inventory_reports WITH INHERIT NOLOGIN; -- cgit v1.2.3