How To Easily Enable All Privileges For A Single Table

This topic is empty.

Viewing 4 reply threads

Author

Posts
- April 28, 2010 at 3:53 pm #11952
  
  Dan Nissenbaum
  Member
  
  Hello –
  
  How is it possible to enable all privileges for a given user with a single click? Currently, I create a new user, deny any global privileges, then open up the Manage Privileges dialog where I must click the checkbox for every possible privilege for a given table just to allow all privileges for the user on that table (but no other table). It seems to me there must be a way to enable all privileges for a given user on a given table in a single click.
  
  For a single user and a single table, having to click 10 or 15 checkboxes isn't the biggest deal – but having to do this for multiple tables and multiple users becomes a real hassle.
  
  Thanks,
  
  Dan
- April 28, 2010 at 5:44 pm #30783
  
  Rohit
  Member
  
  'Dan wrote on '28:
  
  Hello –
  
  How is it possible to enable all privileges for a given user with a single click? Currently, I create a new user, deny any global privileges, then open up the Manage Privileges dialog where I must click the checkbox for every possible privilege for a given table just to allow all privileges for the user on that table (but no other table). It seems to me there must be a way to enable all privileges for a given user on a given table in a single click.
  
  For a single user and a single table, having to click 10 or 15 checkboxes isn't the biggest deal – but having to do this for multiple tables and multiple users becomes a real hassle.
  
  Thanks,
  
  Dan
  
  We are completely rewriting the user manager. The 1st beta containing this feature is expected within 2 weeks.
- April 28, 2010 at 5:54 pm #30784
  
  Dan Nissenbaum
  Member
  
  'Rohit' wrote on '28:
  
  We are completely rewriting the user manager. The 1st beta containing this feature is expected within 2 weeks.
  
  Awesome! Thanks, looking forward
- April 29, 2010 at 5:07 am #30785
  
  navyashree.r
  Member
  
  Requested added in our issue tracker,
  
  http://code.google.com/p/sqlyog/issues/detail?id=1339
  
  Regards,
  
  Navya
- July 21, 2010 at 7:19 am #30786
  
  vishal.pr
  Member
  
  Hi Dan,
  
  We have released 8.6 Beta1 with new User Manager interface.
  
  Please refer to:
  
  http://www.webyog.com/blog/2010/07/20/sqlyog-mysql-gui-8-6-beta1-released/
  
  Regards,
  
  Vishal P.R
Author

Posts