[
http://mifosforge.jira.com/browse/MIFOSBI-261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=65081#comment-65081
]
Van Mittal-Henkle commented on MIFOSBI-261:
-------------------------------------------
Currently there is not a risk of one MFI accessing another MFIs data.
However, this is still a good practice which should be implemented so that
database access is not via root but rather through a user with only the
permissions necessary.
> mifos bi etl job should not require (mysql) super user privileges to run
> --------------------------------------------------------------------------
>
> Key: MIFOSBI-261
> URL: http://mifosforge.jira.com/browse/MIFOSBI-261
> Project: mifos business intelligence
> Issue Type: Bug
> Components: Data Warehouse
> Reporter: Sumit Shah
> Assignee: johnwoodlock
> Priority: Critical
> Fix For: Mifos BI 1.2 - Iteration 1, Mifos BI 1.2
>
>
> when invoking the job as a non-super user (but with ALL privs):
> see this error:
> ERROR 1227 (42000) at line 1346: Access denied; you need the SUPER privilege
> for this operation
> when invoking this file:
> /ETL/MifosDataWarehouseETL/load_mifos_datawarehouse.sql
> line 1436 begins with:
> /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE
> `SPcascade_change_to_accounts`(IN current_customer_key int, IN
> effective_date_param date, IN new_customer_key int,
> IN new_group_key int, IN new_center_key int, IN new_loan_officer_key int, IN
> new_branch_key int,
> i believe DEFINER should be CURRENT_USER
> there are other places in that file with similar code.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
