Chat now with support
Chat with Support

The Quest and One Identity Support Portals will be unavailable on Friday July 10, 2020 from 5:30 PM to 6:30 PM for website maintenance.

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

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

Managing SQL Server objects

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

Topics:

Copying SQL Server objects

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

1
Open the SQL Server Security module.
2
Open the Browse tab.
Related Documents