Hendrik Posted May 2, 2011 Posted May 2, 2011 Hi Support, It makes me wonder, why can't i alter my stored procedures while i can drop and create them? Best Regards, Hendrik
Hendrik Posted May 3, 2011 Author Posted May 3, 2011 I use mysql workbench to execute the changes. I can delete and create routines easily through the tool, but that is a bit annoying when it comes down to small changes which i wanna test out. Previously my database resided in another web-server and there i didn't have any problems with changing the routines. I won't give the full routine as i don't want to publish it, but when i even add a comment to the routine it fails and therefore i think it is unnecessary to view my routine in full content That is what mysql workbench tries to execute. //mysql workbench added code start USE `tazan_ngsis`; DROP procedure IF EXISTS `insertVisitor`; DELIMITER $$ USE `tazan_ngsis`$$ //mysql workbench added code end //my routine start CREATE DEFINER=`tazan_ngsis`@`%` PROCEDURE `insertVisitor`(IN shortUrl TEXT) BEGIN //changed code here END //my routine end After i execute my code i get an error message with this information //mysql workbench added code start ERROR 1370: alter routine command denied to user 'tazan_ngsis'@'%' for routine 'tazan_ngsis.insertVisitor' SQL Statement: DROP procedure IF EXISTS `insertVisitor` ERROR: Error when running failback script. Details follow. ERROR 1304: PROCEDURE insertVisitor already exists //mysql workbench added code end SQL Statement: //changed code here
Guest Geoff Posted May 3, 2011 Posted May 3, 2011 @Hendrik Please post your username/domain/server. Thanks. Possibly related: http://bugs.mysql.com/bug.php?id=9467
Hendrik Posted May 4, 2011 Author Posted May 4, 2011 @Hendrik Please post your username/domain/server. Thanks. Possibly related: http://bugs.mysql.com/bug.php?id=9467 username: tazan domain: ngs.is server: johnny
Guest Geoff Posted May 4, 2011 Posted May 4, 2011 This support request is being escalated to our root admin.
Ashoat Posted May 8, 2011 Posted May 8, 2011 I did some research, and all I know is that cPanel doesn't support it. I couldn't find a rationale, but I imagine it is security-related and could possible have something to do with what Geoff linked to. Sorry, but we can't offer ALTER PROCEDURE support at this point
Guest Geoff Posted May 8, 2011 Posted May 8, 2011 I think we might be able to enable it, but everything happens for a reason in computers, and enabling it might open a security hole or something else bad.
Ashoat Posted May 8, 2011 Posted May 8, 2011 We wouldn't be able to enable it because there needs to be a check mark for it in cPanel's grant privileges dialog.
Recommended Posts