SF.net SVN: ledger-smb:[3561] trunk/sql

[..hidden..]

Revision: 3561
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3561&view=rev
Author:   einhverfr
Date:     2011-07-22 16:12:14 +0000 (Fri, 22 Jul 2011)

Log Message:
-----------
Correction to permissions of chart view

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/upgrade/3290-tax-account.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-07-21 23:15:22 UTC (rev 3560)
+++ trunk/sql/Pg-database.sql	2011-07-22 16:12:14 UTC (rev 3561)
@@ -121,6 +121,8 @@
 SELECT id, accno, description, 'H' as charttype, NULL as category, NULL as link, NULL as account_heading, null as gifi_accno, false as contra, false as tax from account_heading UNION
 select c.id, c.accno, c.description, 'A' as charttype, c.category, concat_colon(l.description) as link, heading, gifi_accno, contra, tax from account c left join account_link l ON (c.id = l.account_id) group by c.id, c.accno, c.description, c.category, c.heading, c.gifi_accno, c.contra, c.tax;
 
+GRANT SELECT ON chart TO public;
+
 COMMENT ON VIEW chart IS $$Compatibility chart for 1.2 and earlier.$$;
 -- pricegroup added here due to references
 CREATE TABLE pricegroup (

Modified: trunk/sql/upgrade/3290-tax-account.sql
===================================================================
--- trunk/sql/upgrade/3290-tax-account.sql	2011-07-21 23:15:22 UTC (rev 3560)
+++ trunk/sql/upgrade/3290-tax-account.sql	2011-07-22 16:12:14 UTC (rev 3561)
@@ -91,6 +91,7 @@
 SELECT id, accno, description, 'H' as charttype, NULL as category, NULL as link, NULL as account_heading, null as gifi_accno, false as contra, false as tax from account_heading UNION
 select c.id, c.accno, c.description, 'A' as charttype, c.category, concat_colon(l.description) as link, heading, gifi_accno, contra, tax from account c left join account_link l ON (c.id = l.account_id) group by c.id, c.accno, c.description, c.category, c.heading, c.gifi_accno, c.contra, c.tax;
 
+GRANT SELECT ON chart TO public;
 
 CREATE OR REPLACE RULE chart_i AS ON INSERT TO chart
 DO INSTEAD


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.