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

To search for SQL Server® objects and permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
4
Select Search | Search in a New Window (Empty).
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.
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.

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.

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.

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

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

1
Open the SQL Server Security module.
2
Open the Browse tab.
4
Select Security | Export.

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

7
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating