FIX: No Information Returned by xp_logininfo (155556)

SYMPTOMS

The extended stored procedure XP_LOGININFO reports the privilege level and the permission path by which a Windows NT user account has access to SQL Server. However, for a domain user (for example, Domain\SQLUser) belonging to a global group (for example, SQLGlobal), "xp_logininfo SQLUser" doesn't return any information if "SQLUser" is granted user level privilege through this global group (xp_grantlogin 'Domain\SQLGlobal', 'user'). Similarly, if the global group is added as a member of a local group (for example, SQLLocal) on the Windows NT server where SQL Server resides and user level privilege is granted to "SQLUser" through the local group "SQLLocal" (xp_grantlogin sqllocal, 'user'), 'xp_logininfo SQLUser' does not return any information either.

In both cases, searching the user's permission path in security manager to "verify permissions for account" and "Find all permissions for account" does not return any information.