SQL Secure enables the ability to drill down to a very specific detail of user access and permissions. By selecting a point in time snapshot, a summary is shown giving the ability to hone in on individual users or users that belong to a group. Selecting a user by default providing overall summary which then it will be enhanced with database specific detail.

Assign permission will show where the users added to security roles and groups. A first step in analyzing where the access is gained and identifying if the user has rights above what is expected based on inheritance.

An effective permission will identify specifically what that inherence means. For example if the user is viewing or changing detail they shouldn’t be in specific table it can be shown exactly where that permission was obtained.

By dynamically creating the script, SQL Doctor makes it easy for you to execute this change, improving the overall performance of your server.

This example shows the update permission was granted by virtue of membership to a contractor’s window security group, something that may be breached in security policy.

Drilling down into role and object of specific permissions will again identify where users are able to gain access. This example takes us specific table and shows inherited permissions, identifying the security from different perspective.

For more information on SQL Secure join us in the community at community.idera.com