SF.net SVN: ledger-smb:[6428] branches/1.3/sql/modules/Roles.sql

[..hidden..]

Revision: 6428
          http://sourceforge.net/p/ledger-smb/code/6428
Author:   pongracz
Date:     2014-01-09 13:15:45 +0000 (Thu, 09 Jan 2014)
Log Message:
-----------
Fix for bug #903 - Cannot delete warehouse. New role and permission added for delete, so, if a user has no rights to delete, he/she will not able to delete an existing warehouse. Please note: I did not find trigger for deleting warehouse - which enable or disable the delete based on items in that warehouse - , so, I cannot predict at this moment, what happens if there are items in the specified warehouse. Delete is useful when one build up a warehouse system but accidentaly setup more than enough or want to wipe out never-used-warehouses. In other words, it could be handy on system setup.

Modified Paths:
--------------
    branches/1.3/sql/modules/Roles.sql

Property Changed:
----------------
    branches/1.3/sql/modules/Roles.sql

Modified: branches/1.3/sql/modules/Roles.sql
===================================================================
--- branches/1.3/sql/modules/Roles.sql	2014-01-08 14:04:35 UTC (rev 6427)
+++ branches/1.3/sql/modules/Roles.sql	2014-01-09 13:15:45 UTC (rev 6428)
@@ -826,6 +826,11 @@
 
 GRANT UPDATE ON warehouse TO "lsmb_<?lsmb dbname ?>__warehouse_edit";
 
+CREATE ROLE "lsmb_<?lsmb dbname ?>__warehouse_delete"
+WITH INHERIT NOLOGIN;
+
+GRANT DELETE ON warehouse TO "lsmb_<?lsmb dbname ?>__warehouse_delete";
+
 INSERT INTO menu_acl (node_id, acl_type, role_name)
 values (143, 'allow', 'lsmb_<?lsmb dbname ?>__warehouse_edit');
 


Property changes on: branches/1.3/sql/modules/Roles.sql
___________________________________________________________________
Added: svn:text-time
## -0,0 +1 ##
+2014-01-09T12:09:37.092430Z
\ No newline at end of property
Added: svn:unix-mode
## -0,0 +1 ##
+0600
\ No newline at end of property
Added: svn:owner
## -0,0 +1 ##
+0 root
\ No newline at end of property
Added: svn:group
## -0,0 +1 ##
+0 root
\ No newline at end of property
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits