Page History

The Explore User Permissions window allows you to explore SQL Server permission information for specific users on audited SQL Servers in your enterprise.SQL Secure provides the option of simply typing in the

Find the permissions associated with a particular user

To view User Permissions, in the Explore Permissions view follow these steps:

1. Click a snapshot from the Audited SQL Servers tree on the left. 
2. Select the Users Permissions tab.
3. Select a user to analyze, it could be a Windows User or Group or SQL Login. 
4. Type the account name of the user for whom you would like to search permissions

...

1. or use the ellipsis button Image Addedto browse all users and groups contained in the collected audit data (snapshot).

...

1.  
2. To view about the options for filtering and finding your users, go to Select a Windows Account or Select a SQL Server Login. 
3. Select the level of permission to analyze, it could be a Server Only or a specific Server and Database. If you select Server Only, SQL Secure searches the permissions in all your current SQL Server instance. If you select Server and Database, you can type a specific database inside your SQL Server or click the ellipsis button Image Added to see all available databases in your server. 

Change the audit data

To change which audit data you are exploring, click the hyperlink text that lists the date and time of the currently selected snapshot (by default, this date and time represents the last successful snapshot).

Find the permissions associated with a particular user

1. Select the SQL Server instance you would like to search from the Audited SQL Servers list.
2. Select to search for a user by either their Windows user name or SQL Login account.
3. Enter the account name of the user to search for or click the Browse button to locate the specific user.
4. Enter the database to search or click the Browse to select the appropriate database.
5. Click Show Permissions. User Permission information appears on the bottom half of the window. The information is displayed on four separate tabstwo sections: Server Logins, and Database Users. The data is also separated into three tabs: Summary, Assigned Permissions, and Effective Permissions.Click Save

You can use the icons on the top right section to save your results or

...

print out a listing of the user's permissions.

...

Change the audit data

To change which audit data you are exploring, click the hyperlink text that lists the date and time of the currently selected snapshot (by default, this date and time represents the last successful snapshot).

Check the password health of a user's login

...