Right Click Options For User Permissions Interface

[TGKnIght]

Functions like check all, clear all, etc…

Maybe even eventually make user configurable permission templates where it would allow you to check off a certain set of permissions on a database.

P.S. Love the work so far I am now relying completely on SQLYog Enterprise after transitioning from MySQL Administrator and Query browser. Looking forward to the continued expansion of it's already impressive functionality. Great job guys!

[Rohit]

Thank you for your encouraging comments 🙂

What you require is called “roles” in other database systems. We believe that it is a server functionality and MySQL AB would implement it at some point in time.

Bascially we want to avoid building functionality that is “best done” by the server!

[peterlaursen]

@rohit …

actually I have been discussing this with Manoj recently.

I think we should have a 'clone user' functionality.

In these organisations where every person has his/her individual MySQL user ID it is quite a monkey job to create 2000 user profiles – of which there are only 12 essentially different ones! Especially where there are hundreds of databases and there is made intensive use of table and column privileges.

With a 'clone user' functionality people could easily build their own 'templates'.

What do you think people do now? I'll tell you:

1) SELECT * from mysql.users where …

2 ) export as SQL .. edit a little .. import again ..

3) 'flush privileges' ..

voila! … 100 times faster than using SQLyog GUI when creating a user identical or almost identical to an eixsting user.

.. and I do realise that this is not quite what TG had in mind! You won't have to tell me

[Author]

Posts