Copy Permission From Windows Based user To Local user

Posted on

Question :

I want to know if it is possible to copy the permissions of a windows user to a locally created user on SQL server?

Answer :

Yes, it is. I guess you mean “Windows Login” and “SQL Server Login”.
You can script permissions using system objects such as sys.database_permissions or using a tool such as Idera SQL permissions extractor.

Leave a Reply

Your email address will not be published. Required fields are marked *