Preserve Grant Info Altering Routines

[ema]

We know there's no a real ALTER command for stored routines (to change the body, i mean).

The standard way is doing 2 steps: drop the routine and create the modified version.

The drop of one object implies the delete of its grants. That's the annoying thing.

It could be great if SQLyog, while editing an object like stored procedure (SP), automatically remembered grants existing before the drop and re-apply them after the create.

That is, the sequence of sql statements SQLyog execute to alter a SP could include “grant execute” command too, at the end (if grants did exist previously).

This feature could be optional (maybe placed in Preferences mask) to let the user have the maximum control.

I hope I was enough clear and that my english wasn't too bad! 🙂

[peterlaursen]

You are clear.  The problem occurs if user editing the Stored Procedure does not have the GRANT privilege.  

[ema]

'peterlaursen' wrote on '12:

You are clear. The problem occurs if user editing the Stored Procedure does not have the GRANT privilege.

If user does not have GRANT privilege, he will receive an error during GRANT phase, but SQLyog will simply work just like now (drop+create will still work).

And if the user with no GRANT priv does not want errors, he can disable the feature in preferences…

But in a working scenario where the root is the only developer for many users (root has GRANT privilege), the feature would be appreciated (obviously, this is my case 🙂 )

Anyway, thanks! Every comment is welcome.

[peterlaursen]

We cannot consider this in 8.6 release as it is 'feature-frozen'.  But I agree there are some problems with user privileges' implementation in MySQL, that it would be nice a GUI tool handled transparently for user (if he so wishes). 

[vishal.pr]

Hi,

Request added to our issue tracker.

Refer to http://code.google.com/p/sqlyog/issues/detail?id=1438

Regards,

Vishal P.R

[Author]

Posts