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