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
Reporter: Sumit Shah
Priority: Critical
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
