The IDERA SQL Secure Effective Permissions tab lists all the effective permissions the user has on server and database objects (contained within the audit filter criteria setup by the user). Effective permissions are the net effect of assigned permissions, permissions inherited from the group or role membership, and covering permissions (SQL Server 2005 and later).
Be aware that calculating effective permissions can take several minutes to run, depending on the number of permissions that have been granted and the complexity of your security model.
Click Calculate Effective Permissions to view all the effective permissions the selected user has (at the time the data collection was taken) on the SQL Server instance being audited.
Available tabs
The Effective Permissions tab contains server and database permission information for the selected user. This includes the object names and types, the type of access granted to the user, and who granted these permissions.
You can save the permissions information to an Excel spreadsheet or print the permissions search. To save or print the permissions information, click the grid on the top right section, and choose the appropriate option.