Hi,
I think this is a pretty basic question however I can't find the answer anywhere on line so here goes
In our prod environment I want to create a user that will be used by both SQL Compare and Data Compare, now hen I've been testing I've created a user and given them access to everything but this would be silly on a live production server.
What permissions/grants/right would a SQLCompare MySQL user need on a server to do it's job?
Thanks and apologies if this is documented somewhere (but I have tried to find it!)
SubPop
I think this is a pretty basic question however I can't find the answer anywhere on line so here goes
In our prod environment I want to create a user that will be used by both SQL Compare and Data Compare, now hen I've been testing I've created a user and given them access to everything but this would be silly on a live production server.
What permissions/grants/right would a SQLCompare MySQL user need on a server to do it's job?
Thanks and apologies if this is documented somewhere (but I have tried to find it!)
SubPop