Monday, 3 August 2015

MySQL noAccessToProcedureBodies=true

Client encounter access rights not enough error as:


Error updating database.  Cause: java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.


Then we grant rights as blow:


GRANT EXECUTE ON PROCEDURE `prodDB`.`spconsolidate_transaction_detail` TO 'user'@'***.***.***.***';
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `prodDB`.* TO 'user'@'***.***.***.***';


GRANT SELECT ON mysql.proc TO 'user'@'***.***.***.***'; # this line must have.




----The End-------



No comments:

Post a Comment