SF.net SVN: ledger-smb:[6830] trunk/sql/modules/Roles.sql

[..hidden..]

Revision: 6830
          http://sourceforge.net/p/ledger-smb/code/6830
Author:   einhverfr
Date:     2014-02-10 10:13:48 +0000 (Mon, 10 Feb 2014)
Log Message:
-----------
permission fixes for defaults and account_link_description tables

Modified Paths:
--------------
    trunk/sql/modules/Roles.sql

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2014-02-10 10:06:15 UTC (rev 6829)
+++ trunk/sql/modules/Roles.sql	2014-02-10 10:13:48 UTC (rev 6830)
@@ -1034,11 +1034,13 @@
                     'custom_table_catalog', 'oe_class', 'note_class']) obj;
 SELECT lsmb__grant_perms('base_user', obj, 'SELECT')
   FROM unnest(array['account_heading'::text, 'account',
-                    'acc_trans', 'account_link', 'defaults']) obj;
+                    'acc_trans', 'account_link', 
+                    'account_link_description']) obj;
                                      -- I don't like loose grants on acc_trans
                                      -- but we need to 
                                      -- change the all years function to be
                                      -- security definer first. -- CT
+SELECT lsmb__grant_perms('base_user', 'defaults', 'ALL');
 SELECT lsmb__grant_perms('base_user', obj, 'SELECT')
   FROM unnest(array['contact_class'::text, 'batch_class',
                     'entity_class', 'lsmb_roles', 'users']) obj;

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


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits