Chat now with support
Chat with Support

Security Explorer 9.9 - User Guide

Getting Started with Security Explorer Managing permissions Searching Managing security Managing objects
Managing folders and files Managing shares Managing registry keys Managing services Managing tasks Managing groups and users Managing Favorites Managing Enterprise Scopes Updating licenses Managing network drives
Working with Microsoft SQL Server Working with Microsoft Exchange
Checking minimum requirements Viewing Exchange permissions Granting Exchange permissions Revoking Exchange permissions Cloning Exchange permissions Searching for Exchange server objects and permissions Backing up and restoring Exchange server security Modifying Exchange permissions Managing Exchange group memberships Exporting Exchange security permissions Creating Exchange databases Creating public folder mailboxes Managing Exchange administrators Managing Exchange distribution groups Managing mail contacts Managing mail users Managing mailboxes Managing mailbox folders Managing public folders Using role based access control Setting options for Exchange security
Working with Microsoft SharePoint Working with Access Explorer Working with Microsoft Active Directory Customizing Security Explorer Using the command line Using PowerShell cmdlets Troubleshooting

Working with Microsoft SQL Server

With the SQL Server Security module, you can manage permissions on SQL Server® instances and databases.

Topics:

•
Viewing SQL Server permissions
•
Granting SQL Server permissions
•
Revoking SQL Server permissions
•
Cloning SQL Server permissions
•
Modifying SQL Server permissions
•
Searching for SQL Server objects and permissions
•
Backing up and restoring SQL Server security
•
Exporting SQL Server database permissions
•
Managing SQL Server objects
•
Managing Security SQL Reporting Services
•
Setting options for SQL Server
•
Modifying SQL Server security settings
•
Managing SQL Server network settings

Viewing SQL Server permissions

 
* 
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.
To view SQL Server® permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
–OR-
Click View Permissions on the Tasks tab.
3
Select an item in the Navigation pane.
–OR-
Type a path, in either drive letter notation or UNC pathname format, in the Path box, and click Go.
The location displays in the Path box. The top right Objects pane displays objects along with the extended information. The bottom right Permissions pane displays permissions for the selected object. The Owner box displays the user or group that owns the selected object.
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.

Granting SQL Server permissions

 
* 
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.
To grant SQL Server® permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
3
Select an item in the Navigation pane, select an object in the Objects pane or a permission in the Permissions pane.
4
Select Security | Grant Permissions.
-OR-
Click on the Tool Bar, click Grant on the Control Button Bar; or right-click the object or permission, and choose 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
From the Permission lists, select a permission to grant. To select more than one permission, select how to apply the permission, and click Permission Selection.
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.
 
* 
NOTE: Only users and groups in the List of users and groups to grant list are affected by the grant action. You can sort each column by clicking the column heading. To remove a selected user or group from the list, click Remove.
8
Click OK. See Completing a process.

Revoking SQL Server permissions

 
* 
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.

To revoke SQL server permissions
9
Open the SQL Server Security module.
10
Open the Browse tab.
11
Select an item in the Navigation pane.
–OR-
Type a path in the Path box, and click Go.
12
Select an object in the Objects pane or a permission in the Permissions pane.
13
Select Security | Revoke Permissions.
-OR-
Click on the Tool Bar, click Revoke on the Control Button Bar; or right-click the object, and choose Revoke Permissions.
14
Select the groups and users to revoke the permission. There are a variety of ways to select groups and users. See Using the Browse tab to revoke permissions.
15
From the Permission list, select the permissions to revoke.
16
Select whether or not to allow or deny all permissions for the selected user.
17
To add the group/user to the List of users and groups to revoke list, click Add.
18
Select options.
 
Table 1. Revoke options
Options
Description

Advanced Revoke Options

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.

Revoke all unknown and deleted accounts

Active only when the Advanced Revoke Options check box is selected. Select to revoke permissions on unknown or deleted accounts.

Revoke all disabled accounts

Active only when the Advanced Revoke Options check box is selected. Select to revoke permissions on all disabled accounts.

Log Actions

Active only when the Advanced Revoke Options check box is selected. Select to create a log file. Browse to name the file.

19
Click OK. See Completing a process.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating