I am hoping to find a simple solution to this problem. I need to copy users roles from windows log ins to database logins. It is easy from windows to windows but when i copy and paste into DB log in I get an error you can not insert from another table.
Windows Login Roles are stored in the Windows Access Control table.
Database Login Roles are stored in the Member Of table.
You could write your own code to transfer the logins / roles, if you have access. If not try searching the downloads here and on Mibuso. There are several dealing with security that might have what you are looking for.
Thanks for pointing me in the right direction Matt.