Chat now with support
Chat with Support

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

Searching for SQL Server objects and permissions

 
* 
TIP: The Search basic task provides a quick way to search for permissions. You also can use the Find Unknown, Find Disabled, and Insecure Passwords advanced tasks to easily search for those specific situations. See Using the Search tasks.
To search for SQL Server® objects and permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
3
Select an object in the Navigation or Objects pane.
4
Select Search | Search in a New Window (Empty).
-OR-
Click on the Tool Bar, or right-click an object, and choose Search in a New Window.
The object you select is added as a Search Scope so you can just set the criteria for the search. See Setting SQL Server search criteria.
If you open the Search tab in the Navigation pane without selecting an object, you need to add a Search Scope before you set criteria. See Adding a search scope.
 
* 
NOTE: If you want to search for passwords, the search scope must be an SQL Server instance and not a database.
5
Click Start Search.

Setting SQL Server search criteria

Each module has a set of search criteria grouped into tabs. As you set criteria, you can update the results by clicking Start Search at any time.

•
To return to the default selections on all tabs, click Defaults.
Search Mode
 
Table 3. Search Mode options
Option
Description

Search for permissions

By default, a search returns permissions based on the specified search criteria.

Search for passwords which are blank or fail a strong password test

Select to search for SQL Server® logins with blank passwords or those where the password is the same as the user name.

Search for a user

Select to search for user logins and database/server role memberships. Type the user names in the box. Separate names with semicolons.

Search for all users

Select to include all accounts in Active Directory®.

Search for unknown accounts

Select to include accounts deleted from Active Directory.

Search for disabled accounts

Select to include accounts that are disabled.

Permission Search Criteria

By default, all Grant, Deny, Inherited, and Explicit permissions are included in the search results. To remove a permissions type from the search, clear the corresponding check box.

You can search for the names of the Grantee and/or Grantor, or Permission types.

•
To include all role memberships, select the check box.
•
To search for Permissions, type the permissions in the box separated by commas, or browse to select permissions from a list.
Permission Search Objects

By default, all permissions are included in the search. To remove a permission from the list, clear the corresponding check box. To remove all permissions, click None. To select all permissions, click All.

Backing up and restoring SQL Server security

 
Table 4. Backup and restore SQL Server® security
Task
Description

Backup

See Backing up security.

Restore

See Restoring security.

Scheduled Backups

See Scheduling a backup.

Exporting SQL Server database permissions

By default, permissions are exported to a report, which you can save, print, or export. You can generate a report or export permissions on an SQL Server® database to a delimited file for use with Microsoft® Excel®.

 
* 
TIP: The Export task provides a quick way to export permissions to a report that you can save, print, or export. See Using the Export task. For more options, click Switch to Security Explorer Classic (Advanced).
To export SQL Server database permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
3
In the Navigation pane, select the database.
4
Select Security | Export.
–OR-
Click on the Tool Bar; or right-click a database, and choose Export.
5
Select the output option.
 
Table 5. Output options
Option
Description

Generate Report

By default, permissions are exported to a report, which you can save, print, or export.

Save to Microsoft Excel(R) Spreadsheet

Permissions can be saved only to a delimited file for use with Microsoft Excel. Select either Comma-delimited file (.CSV) or Tab-delimited file (.TXT).

6
Browse to locate a destination for the file.
7
Click OK.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating