How can we help you today? How can we help you today?

SQL User permission comparison

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.
MarkKlofta
0

Comments

1 comment

Sort by
  • DanC
    Hi @MarkKlofta

    As long as you're not ignoring permissions in the options I believe if there are any differences they will be highlighted.
    DanC
    0

Add comment

Please sign in to leave a comment.