Page History
The IDERA SQL Secure Effective Permissions tab lists all the effective permissions the selected role has on objects in the target database. Effective permissions are the net effect of assigned permissions and permissions inherited from any parent roles.
Click Calculate Effective Permissions to view all the effective permissions the selected role has (at the time the data collection was taken) on the SQL Server instance being audited.
| Note |
|---|
Be aware that calculating effective permissions can take several minutes to run. |
Available tabs
The Effective Permissions tab contains server and database permission information for the selected role. This includes the object names and types, the type of access granted to the role members, and who granted these permissions.
| Tip |
|---|
You can save the permissions information to an Excel spreadsheet, print the permissions search, group or select columns to filter information. You can find these options on the top right section of the Effective Permissions section or by right-clicking any available object and choosing the appropriate option. |