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

[..hidden..]

Revision: 6209
          http://sourceforge.net/p/ledger-smb/code/6209
Author:   einhverfr
Date:     2013-11-03 06:48:58 +0000 (Sun, 03 Nov 2013)
Log Message:
-----------
This should make manage_users sufficient as a role.

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

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2013-10-31 14:12:16 UTC (rev 6208)
+++ trunk/sql/modules/Roles.sql	2013-11-03 06:48:58 UTC (rev 6209)
@@ -942,6 +942,7 @@
 
 SELECT lsmb__create_role('users_manage');
 SELECT lsmb__grant_role('users_manage', 'contact_read');
+SELECT lsmb__grant_role('users_manage', 'contact_class_employee');
 SELECT lsmb__grant_exec('users_manage', 'admin__add_user_to_role(TEXT, TEXT)');
 SELECT lsmb__grant_exec('users_manage', 'admin__remove_user_from_role(TEXT, TEXT)');
 SELECT lsmb__grant_exec('users_manage', 'admin__get_roles_for_user(int)');
@@ -1018,6 +1019,12 @@
 GRANT SELECT ON custom_table_catalog TO public;
 GRANT SELECT ON oe_class TO public;
 GRANT SELECT ON note_class TO public;
+GRANT SELECT ON account_heading TO public;
+GRANT SELECT ON acc_trans TO PUBLIC; -- I don't like this but we need to 
+                                     -- change the all years function to be
+                                     -- security definer first. -- CT
+GRANT SELECT ON contact_class TO PUBLIC;
+GRANT SELECT ON batch_class TO PUBLIC;
 GRANT ALL ON defaults TO public;
 GRANT ALL ON "session" TO public;
 GRANT ALL ON session_session_id_seq TO PUBLIC;

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


------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits