Is there a way to clone users' security and permissions in Microsoft SQL Server, preferably using the SQL Server Management Studio GUI?
How to Clone a User in SQL Server 2008 R2
permissionssql serversql-server-2008ssms
Related Question
- SQL Server – Re-Add User After Moving Database
- SQL Server Management Studio – How to Quickly Clone a Database
- SQL Server 2008 R2 – Copy Schema with User Security Permissions
- SQL Server Permissions – Create a User Account Login That Cannot Login from SSMS
- Sql-server – How to clone a database in Microsoft SQL server using PHP
- Sql-server – Query for: view users and permissions (roles) from root security folder (MS SQL)
Best Answer
Note : The below script doesn't actually set the permissions on anything, it just creates the script that can be copied and pasted to a new query, which can then be edited before being executed.
Below script will help you copy/clone permissions of one user to another: