[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [1572] trunk
- Subject: SF.net SVN: ledger-smb: [1572] trunk
- From: ..hidden..
- Date: Tue, 11 Sep 2007 22:18:40 -0700
Revision: 1572
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1572&view=rev
Author: einhverfr
Date: 2007-09-11 22:18:40 -0700 (Tue, 11 Sep 2007)
Log Message:
-----------
Correcting validation issues in frameset
Modified Paths:
--------------
trunk/UI/frameset.html
trunk/sql/modules/Roles.sql
Modified: trunk/UI/frameset.html
===================================================================
--- trunk/UI/frameset.html 2007-09-12 00:26:53 UTC (rev 1571)
+++ trunk/UI/frameset.html 2007-09-12 05:18:40 UTC (rev 1572)
@@ -1,5 +1,5 @@
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN"
+ "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
<head>
<title><?lsmb title ?></title>
Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql 2007-09-12 00:26:53 UTC (rev 1571)
+++ trunk/sql/modules/Roles.sql 2007-09-12 05:18:40 UTC (rev 1572)
@@ -481,6 +481,15 @@
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;
+
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (16, 'allow', 'lsmb_<?lsmb dbname ?>__list_all_open');
+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
WITH INHERIT NOLOGIN
lsmb_<?lsmb dbname ?>__create_pos_invoice,
@@ -495,9 +504,30 @@
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;
+
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (35, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (45, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
+
+
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;
+
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (35, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (41, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (44, 'allow', 'lsmb_<?lsmb dbname ?>_reconcile');
+
+
CREATE ROLE lsmb_<?lsmb dbname ?>__all_reconcile
WITH INHERIT NOLOGIN
IN ROLE lsmb_<?lsmb dbname ?>__reconcile,
@@ -505,12 +535,32 @@
CREATE ROLE lsmb_<?lsmb dbname ?>__process_payment
WITH INHERIT NOLOGIN
-IN ROLE ar_list_transactions;
+IN ROLE ap_list_transactions;
+GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__process_payment;
+
+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 ap_list_transactions;
+IN ROLE ar_list_transactions;
+GRANT INSERT ON acc_trans TO lsmb_<?lsmb dbname ?>__process_receipt;
+
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (35, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (36, 'allow', 'lsmb_<?lsmb dbname ?>__process_receipt');
+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
WITH INHERIT NOLOGIN
IN ROLE lsmb_<?lsmb dbname ?>__all_reconcile,
@@ -521,6 +571,24 @@
CREATE ROLE lsmb_<?lsmb dbname ?>__create_part
WITH INHERIT NOLOGIN;
+GRANT INSERT ON parts TO lsmb_<?lsmb dbname ?>__create_part;
+
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (77, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (78, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (79, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (80, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
+INSERT INTO menu_acl (node_id, acl_type, role_name)
+values (81, 'allow', 'lsmb_<?lsmb dbname ?>__create_part');
+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
+WITH INHERIT NOLOGIN;
+
CREATE ROLE lsmb_<?lsmb dbname ?>__inventory_reports
WITH INHERIT NOLOGIN;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.