MySQL Forums :: Workbench - Database Administration :: Maintaining Functions/Procedures from multiple sites
Maintaining Functions/Procedures from multiple sites
Posted by: george gallen ()
Date: January 04, 2012 08:24PM
My website host has MySQL as an option. If I Administer the database from work, and create any functions or procedures, I am unable to view and/or update them from home, because of the "Definer clause" which is automatically added (not sure if Workbench is adding it, or the database).
Right now, I keep a copy of all my functions and procedures on a flashdrive, and if I'm at a location where I didn't create the function, I have to drop it, then add it back it, which gets a little old, especially, if I've made a change, and hadn't saved it to my flash drive...uggg.
Is there a setting or a way to have the database ignore the definer clause?
GG
Right now, I keep a copy of all my functions and procedures on a flashdrive, and if I'm at a location where I didn't create the function, I have to drop it, then add it back it, which gets a little old, especially, if I've made a change, and hadn't saved it to my flash drive...uggg.
Is there a setting or a way to have the database ignore the definer clause?
GG
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Maintaining Functions/Procedures from multiple sites | 1171 | george gallen | 01/04/2012 08:24PM |
| Re: Maintaining Functions/Procedures from multiple sites | 622 | Mike Lischke | 01/05/2012 03:05AM |
| Re: Maintaining Functions/Procedures from multiple sites | 555 | george gallen | 01/05/2012 11:07AM |
| Re: Maintaining Functions/Procedures from multiple sites | 867 | george gallen | 01/05/2012 02:02PM |
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.
© 2013, Oracle Corporation and/or its affiliates