Hi Aastha, I think that you can develop a Plugin to do it.
Recently, I post a plugin that allow authenticate users through LDAP Server ( http://nafiux.com/blog/2012/08/16/mysql-ldap-authentication-plugin-clear-password-client-plugin/ ). More info about MySQL Authentication Plugins: http://dev.mysql.com/doc/refman/5.5/en/authentication-plugins.html You can build your own plugin with your needs. Best regards. On Wed, Aug 22, 2012 at 9:13 AM, Aastha <aast...@gmail.com> wrote: > Hello, > > I want to create users and give access to different schema within the > database. > I also want to give them selective privileges to access the table in > different schema. > > One way is to create users in MySQL and then grant with privileges. > > Is there any way to give them access to MySQL database and the tables > within the schema using active directory. > Also. is there a way to create group of privileges and assign users to the > group required. > > > Thanks, > Aastha Gupta > -- Ignacio Ocampo Millán