The IDERA SQL Secure Assigned Permissions tab lists all the explicitly defined permissions that apply to calculating the users' effective permissions. This includes groups, roles, and aliases; as well as, covering permissions available in SQL Server 2005 or later.