grants on particular stored routines in user manager
| User, date | Message |
|---|---|
|
Written by Tribal
3 years ago Category: General 23 posts since Thu, 28 Oct 10 |
hey anse, is there any way to manage grants on particular stored routines (and maybe other objects, didn't test it yet) in the user manager? my problem is i can't see weather a user has the execute privilege on a stored routine 'cause apparently the user manager also treats stored routines as tables so i can't tick any execute privilege checkbox :( the only solution (as i found out yet) would be granting the execute privilege on the whole database to the user, but i only want him to call one single routine, nothing else... sure, i can manage that via a simple grant command in the query tab but thats not the reason i'm using such a powerful pease of software  and besides that it still wouldn't solve my problem not seeing wether the user has that specific privilege...thanks in advance, tribal |
|
Written by Tribal
3 years ago 23 posts since Thu, 28 Oct 10 |
ohh, should read piece, not pease 
|
|
Written by ansgar
3 years ago 3977 posts since Fri, 07 Apr 06 |
Did you see the "Add privilege" button? That's for adding privs to single objects. |
|
Written by Tribal
3 years ago 23 posts since Thu, 28 Oct 10 |
yes, actually i did ^^ but when selecting the routine and adding it to the privilege list its represented as a table with its appertaining privs and the execute priv certainly doesn't belong to a tables ones so consequently it's currently not possible for me to grant the execute priv on one single routine via the user manager as there simply isn't no checkbox to tick
|
|
Written by ansgar
3 years ago 3977 posts since Fri, 07 Apr 06 |
Oh I see what you mean now. Well, there is no routine specific privilege in the managed table mysql.tables_priv . HeidiSQL does currently nothing with the potentially existing mysql.procs_priv - that's the problem. Think the whole dialog code needs again a refactoring in order to implement that. |
|
Written by ansgar
3 years ago 3977 posts since Fri, 07 Apr 06 |
Refactoring done in r3585. Hope you like it. |
|
Written by Tribal
3 years ago 23 posts since Thu, 28 Oct 10 |
well done, exactly what i've been looking for :) the only thing that could confuse some is the fact that a privilege object doesn't become deleted until unchecking it completely and saving the privileges...but as far as i can see that's not quite so urgent ;) thanks again! |
|
Written by ansgar
3 years ago 3977 posts since Fri, 07 Apr 06 |
I already thought about that, where previous versions had a delete button which I have removed now. I think that button could also confuse users, when having unchecked privileges. Probably something which just needs some hint. |
|
Please login to leave a reply, or register at first. |