Allow MSSQL database cloning with different users
Actually the cloned MSSQL database will be accessible to same users as the source database.
You cannot copy over an existing database with no users in common.
You cannot ever change access rights for such user, if the database contains an user-defined table (see: https://snag.gy/HJbdQU.jpg). Please note that the link "Search for related Knowledge Base articles" is broken.