From: Johan De Meersman
Date: April 17 2013 1:34pm
Subject: Re: Doubt with stored procedures
List-Archive: http://lists.mysql.com/mysql/229285
Message-Id: <28115947.21804.1366205673317.JavaMail.root@tuxera.be>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
----- Original Message -----
> From: "Antonio Fern=C3=A1ndez P=C3=A9rez"
> Subject: Doubt with stored procedures
>=20
> 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 detai=
l, 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 bo=
th GRANT and CREATE PROCEDURE are replicated, so both all procedures and al=
l users should logically exist on both sides of a replication setup.
--=20
Linux Kriek Wanderung
April 19-21, 2013
http://www.tuxera.be/lkw