How do I see effective permissions for a user or group for a SQL server object or whole server?
For example, a user is not listed in security/logins, but he is a member of few groups and some of them have assigned permissions on SQL server (again either directly or through
membership in other groups)
Even when I select an object (a table), check properties/permission – it doesn’t let me select any principal, except those listed on security/logins…
Anyway, what is the right way to see effective permissions for a user or group?
Sorry for asking such a simple question, I’ve searched but found nothing relevant.
View Complete Post