|
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.
|
1 |
Open the SQL Server Security module. |
|
3 |
|
7 |
To assign permissions to the role, open the Permissions tab. Use the scroll bar or adjust the panes as necessary to view the contents. |
|
1 |
Open the SQL Server Security module. |
|
3 |
Select a database role, and select Tools | Delete. |
|
4 |