I have several DBs with UserA and UserB.
In some of those DBs, impersonation has been granted (GRANT IMPERSONATE ON LOGIN::UserA TO UserB), in other DBs users have no impersonation.
How can I check with a query if a user has got the impersonation or not? Does a flag exist in any system table for this?