user accounts using Active Directory

[Aastha]

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