We are migrating an application from SQL2000 to SQL2005 and changing the authentication mode from SQL to windows integrated.
The application accepts SSI credentials, but behaves wrong because need to know the role membership of the user to show the menus.
Seems to use sp_helpuser to know the DBrole for the DBuser,
select suser_name() returns the ADuser name but the ADuser being member of an ADgroup declared as DBuser returns nothing when using sp_helpuser.
If we give sp_helpuser the ADgroup name, returns the needed value in the GroupName column.
So, is there any way to know the ADgroup membership for a ADuser?
The application vendor wants me to declare manually each ADuser as login, DBuser and DBrole member!!!!
Any idea would be appreciated.