----- Original Message ----- > From: "Antonio Fernández Pérez" <antoniofernan...@fabergames.com> > Subject: Doubt with stored procedures > > I have a doubt with stored procedures functionality. Is possible that > a stored procedure works with all databases form the server? I have > created a stored procedure on dataBaseA and also works with dataBaseB. Is that > correct? Independently of the user privileges defined.
Yes, that's all part of the mysql magic, any stored procedure ever defined will work on any server ever to exist. Well, either that, or you might want to provide us with a little more detail, including but not limited to: * Is this MySQL or NDB Cluster? * Software version? * What is the relation between the servers (master, slave, master/master, ...) ? * how exactly did you define the SP, using what user etc. ? * how are you calling the SP, using what user, ... ? * ... That being said, using a set of default assumptions, I can tell you that both GRANT and CREATE PROCEDURE are replicated, so both all procedures and all users should logically exist on both sides of a replication setup. -- Linux Kriek Wanderung April 19-21, 2013 http://www.tuxera.be/lkw -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
