----- Original Message -----
> From: "Antonio Fernández Pérez"
> 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