From: Ignacio Ocampo Date: August 22 2012 2:17pm Subject: Re: user accounts using Active Directory List-Archive: http://lists.mysql.com/mysql/228050 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=e89a8f923ba0899a7704c7db68be --e89a8f923ba0899a7704c7db68be Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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-pa= ssword-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 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 th= e > group required. > > > Thanks, > Aastha Gupta > --=20 Ignacio Ocampo Mill=E1n --e89a8f923ba0899a7704c7db68be--