is it safe to run this statement against mysql.proc
update mysql.proc set DEFINER = 'abcd@localhost' where definer like '%';
I want all my stored procs (matching a certain pattern) to run under (DEFINER) the SAME 'abcd@localhost' user account on the production server. I'm thinking that if this user has the SUPER priv, and my app server has the EXECUTE priv, then MySQL won't have to do much work checking security under high load.
Can I modify all procs in batch like this or will it screw up something in the mysql database??
Thanks
Dewey
Subject
Views
Written By
Posted
is it safe to run this statement against mysql.proc
3736
June 20, 2007 03:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.