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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center