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.
3
Select an item in the Navigation pane, select an object in the Objects pane or a permission in the Permissions pane.
4
Select Security | Grant Permissions.
-OR-
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.
6
From the Permission lists, select a permission to grant. To select more than one permission, select how to apply the permission, and click Permission Selection.
7
To add the group/user to the List of users and groups to grant list, click Add. The selection is added to the list.
 
* 
NOTE: Only users and groups in the List of users and groups to grant list are affected by the grant action. You can sort each column by clicking the column heading. To remove a selected user or group from the list, click Remove.
8
Click OK. See Completing a process.

Revoking SQL Server permissions

 
* 
TIP: The Revoke basic task provides a quick way to revoke permissions. You also can use the Revoke Unknown and Revoke Disabled advanced tasks to easily revoke permissions for those specific situations. See Using the Revoke tasks.

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.

To revoke SQL server permissions
9
Open the SQL Server Security module.
10
Open the Browse tab.
11
Select an item in the Navigation pane.
–OR-
Type a path in the Path box, and click Go.
12
Select an object in the Objects pane or a permission in the Permissions pane.
13
Select Security | Revoke Permissions.
-OR-
Click on the Tool Bar, click Revoke on the Control Button Bar; or right-click the object, and choose Revoke Permissions.
14
Select the groups and users to revoke the permission. There are a variety of ways to select groups and users. See Using the Browse tab to revoke permissions.
15
From the Permission list, select the permissions to revoke.
16
Select whether or not to allow or deny all permissions for the selected user.
17
To add the group/user to the List of users and groups to revoke list, click Add.
18
Select options.
 
Table 1. Revoke options
Options
Description

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.

19
Click OK. See Completing a process.

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.
3
Select an object in the Objects pane or a permission in the Permissions pane.
4
Select Security | Clone Group or User.
-OR-
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.
 
* 
IMPORTANT: Do not select a pair of accounts where the source is the same as the target. The permissions for the accounts will be deleted as a result of the cloning process.
7
Click Add. The selected pair displays in the List of users and groups to clone list.
•
To clear all pairs from the list, click Clear.
•
To remove selected user(s) or groups(s) from the list, click Remove.
8
Select options.
 
Table 2. Clone options
Options
Description

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.

9
Click OK. See Completing a process.

Modifying SQL Server permissions

To modify SQL Server® permissions
1
Open the SQL Server Security module.
2
Open the Browse tab.
3
In the Permissions pane, select a permission.
4
Select Security | Modify Permissions.
-OR-
Click on the Tool Bar, click Modify on the Control Button Bar; or right-click the permission, and choose Modify Permissions.
 
* 
NOTE: The available permission types vary according to the type of object that is selected.
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.
5
Select the permissions.
6
Click OK.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating