With the SQL Server Security module, you can manage permissions on SQL Server® instances and databases.
NOTE: If the Always open authentication dialog check box is selected on the SQL tab of the Options dialog box, the SQL Authentication box appears. Enter the necessary credentials, and click OK. See Setting options for SQL Server. |
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Show permissions to display permissions (default) for a selected object. Clear the check box to prevent the display of permissions in all windows and dialog boxes. This setting reverts to the default each time you open Security Explorer. |
TIP: The Grant task provides a quick way to grant permissions. See Using the Grant task. For more options, add a path, and click Switch to Security Explorer Classic (Advanced). The path carries to the Grant SQL Permissions dialog box, but the permissions do not. |
1 |
Open the SQL Server Security module. |
2 |
Open the Browse tab. |
4 |
Select Security | Grant Permissions. |
5 |
Select a group or user from the list or click User Selection to select a group/user who is not displayed. |
6 |
7 |
To add the group/user to the List of users and groups to grant list, click Add. The selection is added to the list. |
8 |
TIP: The Revoke basic task provides a quick way to revoke permissions. You also can use the Revoke Unknown and Revoke Disabled advanced tasks to easily revoke permissions for those specific situations. See Using the Revoke tasks.
For more options, add a path, and click Switch to Security Explorer Classic (Advanced). The path carries to the Revoke SQL Permissions dialog box, but the permissions do not. |
9 |
Open the SQL Server Security module. |
10 |
Open the Browse tab. |
13 |
Select Security | Revoke Permissions. |
14 |
If you select this check box, a warning message displays and the Revoke SQL Permissions dialog box becomes inactive, so the other users/groups and permissions you selected are not included in this action. To continue, click Yes. | |
Active only when the Advanced Revoke Options check box is selected. Select to revoke permissions on unknown or deleted accounts. | |
Active only when the Advanced Revoke Options check box is selected. Select to revoke permissions on all disabled accounts. | |
Active only when the Advanced Revoke Options check box is selected. Select to create a log file. Browse to name the file. |
19 |
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center