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

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.

Cloning SQL Server permissions

TIP: The Clone task provides a quick way to clone permissions. For more options, add a path, and click Switch to Security Explorer Classic (Advanced). The path carries to the Clone SQL Permissions dialog box, but the permissions do not.
To clone SQL Server® permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
4
Select Security | Clone Group or User.
Click on the Tool Bar, click Clone on the Control Button Bar; or right-click the object, and choose Clone Group or User.
5
In the Source Group or User area, click User Selection to select the domain or object from which to pull the permissions.
6
In the Destination Group or User area, click User Selection to select the domain or object to receive the cloned permissions.
7
Click Add. The selected pair displays in the List of users and groups to clone list.
Table 2. Clone options

Clone Permissions

By default, permissions are cloned.

Clone group memberships

Select to add the destination account to the groups of which the source user is a member.

Modifying SQL Server permissions

To modify SQL Server® permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
4
Select Security | Modify Permissions.
Click on the Tool Bar, click Modify on the Control Button Bar; or right-click the permission, and choose Modify Permissions.
NOTE: If you want to change to another Principal name, click Change. The Select objects box lists the available objects. Select another name, and click OK.
6
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating