Lowell (4/9/2014)

---

as usual, it depends on what you are looking for: object level permissions? ie does user mydomain\lowell have SELECT permissions on HR.dbo.Payroll?

did you find any script that was close to what you are after so we can use that as a starting point?

you can get explicitly declared permissions assigned to a user.

then you need to get any explicitly granted permissions to the role(s) the user belongs to.

then there what i call implied permissions, which are the permissions that you inherit from fixed database roles/server roles; it's possible that mydomain\lowell is not even an explicit login/user int he database, but comes in via a windows group.

if you can define what you are after, we can help further.