All users have access to my database via a security group maintained in active directory. One user seems to get access, regardless of weather or not i deny connect to the server for this security group.
How do i find out what other groups this user is part of, or what other permissions he has?
ive tried fn_my_permissions, but it gives no usefull info:
SELECT * FROM fn_my_permissions('username', 'user');
GO
entity_namesubentity_namepermission_name
------------------------------------------
username IMPERSONATE