Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Right Click Options For User Permissions Interface

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Right Click Options For User Permissions Interface

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • August 21, 2006 at 8:46 am #22100
      Rohit
      Member

      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!

    • August 21, 2006 at 9:19 am #22101
      peterlaursen
      Participant

      @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
Viewing 1 reply thread
  • You must be logged in to reply to this topic.