Chat now with support
Chat with Support

Security Explorer 9.8 - 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

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.
Click View Permissions on the Tasks tab.
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.
4
Select Security | Grant Permissions.
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.

Revoking SQL Server permissions

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.
Click on the Tool Bar, click Revoke on the Control Button Bar; or right-click the object, and choose Revoke Permissions.

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.

Related Documents