In the SQL Security module, you can manage SQL Server® Databases, Logins, and Server roles.
You can copy database users from one database to another, and logins from one SQL Server® instance to another.
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Security | Copy Permission. |
NOTE: To select all permissions in the list, select Security | Select All Permissions, or right-click in the Permissions pane, and choose Select All Permissions. |
6 |
Select Security | Paste Permissions. |
You can view the assemblies, functions, stored procedures, synonyms, tables, and views for SQL Server® databases by expanding the category in the Navigation pane. You also can add, edit, and delete database roles and users, and add or delete schemas.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center