MySQL Forums :: Workbench - Database Administration :: Maintaining Functions/Procedures from multiple sites

OK. This is what I found:


1. If I create a procedure/function using Workbench and do not include the definer clause (Or if I use the command line interface), The MySQL database puts in the definer clause automatically based on my current IP address.

2. If I try to use a definer clause where the IP address is different from my current IP address, I get an error "Must have SUPER Privleges"

3. If I try to view a procedure/function using Workbench from an ip different from the definer ip address, it fails - no error, just doesn't open up an edit box.

Sounds like my hosting company locked down the procedures/functions so that one user can not view another users procedures based on the definer clause and the IP is part of the user key in the definer clause, so it seems like this is a side effect of the security of the hosting company.