Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Security Explorer 9.9 - User Guide

Table of Contents

Getting Started with Security Explorer

Starting Security Explorer

Using the Navigation pane Using the Objects pane Using the Permissions pane

Customizing the view

Choosing an interface mode Using the Tasks tab Using the status bar Using the loading progress bar Managing module buttons

Completing a process

Managing permissions

Viewing permissions Granting permissions

Using the Browse tab to grant permissions Using the Grant task

Revoking permissions

Using the Browse tab to revoke permissions Revoking permissions on unknown accounts Revoking permissions on disabled accounts Using the Revoke tasks

Cloning permissions

Using the Browse tab to clone permissions

Selecting users and groups manually Selecting users and groups automatically Updating permissions relating to a user's SID history Importing users and groups

Using the Clone task

Creating permission templates Copying permissions Copying permissions to subfolders and files Setting ownership

Using the Browse tab to set ownership Using the Set Ownership task

Modifying permissions Reducing permissions to read only Managing group memberships Renaming accounts Deleting permissions

Deleting permissions by searching

Printing permissions

Running a report using the Browse tab Running a report using the Reports or Tasks tab

Using the Browse tab to search Managing saved searches Adding a search scope Setting search criteria

Group and user search criteria Permission search criteria Folder and file search criteria Service and task search criteria Group and user search criteria Advanced search options Registry key search criteria

Using the Search tasks Replacing permissions Scheduling a search Managing search tasks

Managing security

Backing up security

Using the Browse tab to back up security Using the Backup task

Scheduling a backup Using the backup scheduler Restoring security

Setting advanced options for the restore process

Comparing security Purging backup files Scheduling a backup purge Exporting security

Using the Browse tab to export security Using the Export task Scheduling an export Managing export tasks

Managing objects

Managing folders and files

Creating a new folder Deleting a folder or file Viewing folder and file properties Showing open files Opening files Editing files Opening a folder in Windows Explorer

Managing shares

Creating a new share Removing a share Finding a share path

Managing registry keys

Creating a new registry key Deleting a registry key Modifying registry values

Managing services

Starting, stopping, pausing, or restarting a service Setting logon accounts Changing the password for a logon account Scheduling logon account password changes Removing a service Modifying service properties

Running a task Setting account information Creating a new task Copying a task Exporting a task Removing a task Modifying task properties

Managing groups and users

Viewing accounts Creating a new group Creating a new user Modifying group and user properties Modifying group or user Active Directory properties Modifying properties of multiple users Modifying group memberships Viewing group and user memberships Changing user passwords Modify memberships of multiple local groups Clearing the local administrator group Deleting groups and users Creating a new Managed Service Account Modifying Managed Service Account properties Modifying Managed Service Account Active Directory properties Viewing Managed Service Account memberships Deleting Managed Service Account

Managing Favorites

Adding Favorites Exporting Favorites Importing Favorites Removing Favorites

Managing Enterprise Scopes

Creating an Enterprise Scope while browsing Creating an Enterprise Scope Editing an Enterprise Scope Removing an Enterprise Scope

Updating licenses Managing network drives

Mapping a network drive Disconnecting a network drive

Working with Microsoft SQL Server

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

Setting SQL Server search criteria

Backing up and restoring SQL Server security Exporting SQL Server database permissions Managing SQL Server objects

Copying SQL Server objects Copying SQL Server permissions Managing SQL Server databases

Adding a new database role Removing a database role Modifying a database role Adding a new database user Removing a database user Modifying a database user Adding a new schema Removing a schema Modifying a schema

Managing logins

Adding a new login Removing a login Modifying a login

Managing server roles

Adding a server role Removing a server role Modifying server roles

Managing Security SQL Reporting Services

Managing system roles

Creating a new system role Deleting system roles Modifying a system role

Managing catalog roles

Creating a new catalog role Deleting catalog roles Modifying a catalog role

Managing catalog items

Granting SSRS permissions Revoking SSRS permissions Cloning SSRS permissions Searching for SSRS permissions Modifying SSRS permissions Copying SSRS permissions Deleting SSRS permissions Exporting SSRS permissions Backing up and restoring SSRS permissions

Setting options for SQL Server Modifying SQL Server security settings Managing SQL Server network settings

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

Setting Exchange security search criteria

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

Adding Exchange administrators Modifying Exchange administrators Deleting Exchange administrators

Managing Exchange distribution groups Managing mail contacts

Creating mail contacts Modifying mail contacts Deleting mail contacts

Managing mail users

Creating mail users Modifying mail users Deleting mail users

Managing mailboxes

Creating mailboxes Modifying mailbox settings Deleting mailboxes

Managing mailbox folders

Creating mailbox folders Managing permissions on mailbox folders for multiple users Deleting mailbox folders

Managing public folders

Creating public folders Modifying public folder settings Deleting public folders

Using role based access control

Managing user roles

Adding a user role Modifying user roles Deleting user roles

Managing role groups

Adding role groups Modifying role groups Deleting role groups

Creating assignments Modifying assignments Deleting assignments Creating child roles Modifying child roles Deleting child roles Adding entities Modifying entities Deleting entities

Managing custom scopes

Creating a custom scope Editing a custom scope Deleting custom scopes

Setting options for Exchange security

Working with Microsoft SharePoint

Using the SharePoint menu Adding SharePoint farms or sites Managing SharePoint farms or sites Previewing SharePoint objects Deploying the SharePoint web service Deploying the SharePoint web service manually Managing SharePoint permissions

Viewing SharePoint permissions Granting SharePoint permissions Revoking SharePoint permissions Cloning SharePoint permissions Modifying SharePoint permissions Modifying SharePoint permissions levels Repairing limited access permissions Removing permissions on deleted accounts Removing permissions on disabled accounts

Managing SharePoint groups Removing accounts from SharePoint groups Searching for SharePoint objects

Setting SharePoint security search criteria

Group and user search criteria Permission search criteria SharePoint Search Criteria

Modifying SharePoint properties Backing up and restoring SharePoint security Exporting SharePoint permissions

Deleting export tasks

Setting SharePoint options Removing the SharePoint web service Removing the SharePoint web service manually

Working with Access Explorer

Access Explorer components

Managed domain Registered forest Managed computer Access Explorer agent Scopes Database Service accounts

Setting up Access Explorer

Setting up the Access Explorer database Setting up the first managed domain (includes the service account)

Updating Access Explorer configuration

Adding managed domains Adding forests Editing managed domains or forests Adding service accounts Editing service accounts Deleting service accounts

Collecting Access Explorer data

Setting up a managed computer Installing the Access Explorer agent locally Installing the Access Explorer agent remotely

Windows Servers NAS Servers Clusters

Managing managed computers Modifying managed computer properties

Adding a keyword Changing the scan schedule Modifying the scope of a scan

Managing Access Explorer agents

Viewing agent details Changing the service account Adding an agent to a locally-managed computer Adding an agent to a remotely-managed computer Removing a managed computer Restarting an agent Understanding the status of your agent

Viewing Access Explorer objects

Viewing groups and users Viewing computers Viewing resource groups Viewing permissions

Searching Access Explorer servers Using the Access Explorer permission wizard

Changing all permissions Cloning all permissions Deleting all permissions Exporting all permissions Backing up permissions

Setting options for Access Explorer

Working with Microsoft Active Directory

Viewing Active Directory permissions Granting Active Directory permissions Revoking Active Directory permissions Cloning Active Directory permissions Searching for Active Directory objects Modifying Active Directory permissions Modifying group memberships Modifying Active Directory properties Deleting Active Directory permissions Backing up and restoring Active Directory security Exporting Active Directory permissions

Using the Active Directory Export task

Setting options for Active Directory Security

Customizing Security Explorer

Setting general options Setting view options Setting alternate credentials for workgroups Setting alternate credentials for services and tasks Setting alternate credentials NAS devices Setting advanced options Controlling access to Security Explorer

Using the command line

Opening a command prompt window SxpBackup.exe SxpClone.exe SxpExport.exe SxpGrant.exe SxpHomeDir.exe SxpInheritance.exe SxpOwner.exe SxpRestore.exe SxpRevoke.exe SXPActiveDirectoryBackup SxpSearch.exe

Using PowerShell cmdlets

What are cmdlets? Using Security Explorer cmdlets

Creating or editing the PowerShell.exe.config file Installing Security Explorer cmdlets Installing Security Explorer cmdlets manually Removing Security Explorer cmdlets

Using cmdlets to set up Access Explorer

Creating the Access Explorer database Adding a service account Adding a domain to manage Adding managed computers

Using cmdlets to get information about Access Explorer objects

Getting service account information Getting managed domain information Getting managed computer information Getting security information for a resource Getting resource access information

Using cmdlets to manage Access Explorer agents

Identifying agents on a managed computer Changing the agent configuration on a managed computer Restarting the agent Restarting a single agent Updating an agent Changing the service account password Changing the SQL account password

Using cmdlets to remove Access Explorer objects

Removing a managed computer Removing a managed domain Removing a service account

Troubleshooting

Repairing inheritance Creating test folders and files Using log files SharePoint web service removal fails Uninstalling Security Explorer

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.

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

Managing SQL Server objects

In the SQL Security module, you can manage SQL Server® Databases, Logins, and Server roles.

•

Copying SQL Server objects

•

Copying SQL Server permissions

•

Managing SQL Server databases

•

Managing logins

•

Managing server roles

Copying SQL Server objects

You can copy database users from one database to another, and logins from one SQL Server® instance to another.

To copy SQL Server objects

1

Open the SQL Server Security module.

2

Open the Browse tab.

3

Right-click a login or a database user in the Navigation or Objects pane, and choose Copy Object.

4

Select a new location, such as another database, right-click, and choose Paste Object.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center