Re: create roles/groups in MYSQL

2012-08-02 Thread Andrew Moore
There's nothing built in but if you want explore this it is an extension http://www.securich.com/ On 1 Aug 2012 21:56, Aastha aast...@gmail.com wrote: Hello, I have 10 different users and i have to give different accesses to different tables. Is it possible to create a groups with

Re: create roles/groups in MYSQL

2012-08-02 Thread Martijn Tonies
There's nothing built in but if you want explore this it is an extension http://www.securich.com/ That seems like a nice extension. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL,

create roles/groups in MYSQL

2012-08-01 Thread Aastha
Hello, I have 10 different users and i have to give different accesses to different tables. Is it possible to create a groups with different set of access rights on different tables. I know there are ROLES and PROFILES in Oracle. Is there something similar in MySQL. Thanks, Aastha Gupta

RE: create roles/groups in MYSQL

2012-08-01 Thread Rick James
Sorry, nothing like Roles or Profiles. Copy Paste. -Original Message- From: Aastha [mailto:aast...@gmail.com] Sent: Wednesday, August 01, 2012 1:56 PM To: mysql@lists.mysql.com Cc: Aastha Subject: create roles/groups in MYSQL Hello, I have 10 different users and i have