SQL User permission comparison
MarkKlofta
Posts: 1 New member
in SQL Compare
Hi Guys
I have two identical databases. One on one site and one on another. There is also a user with the same name created on each of these SQL servers and I would like to compare the permissions between the two databases on all tables, procs, functions etc.
How do I achieve this?
Please help.
I have two identical databases. One on one site and one on another. There is also a user with the same name created on each of these SQL servers and I would like to compare the permissions between the two databases on all tables, procs, functions etc.
How do I achieve this?
Please help.
Tagged:
Answers
As long as you're not ignoring permissions in the options I believe if there are any differences they will be highlighted.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?