Currently I have a scenario wherein a user has logged in via the Windows
Authentication to the SQL Server 2005 using SQL Server Management Studio. Now
the user does to what all database roles(like db_datareader,db_datawriter
etc..) he has access to and what all Server Roles he as access to.
(Since there are 2 kinds of roles (1)Database Roles (2) Server Roles )
Now When the user expands the logins folder in the SQL Server Management
Studio , he sees several Windows NT Active Directory Security Groups listed
over there , but does not see his windows NT login Id listed over there. This
means to see that he must be belonging to one of the Active Directory's
Security Group. Since Domain\Domain Users is one of the groups listed over
there, he would belong to that group and may be one more Security Group. Now
is there is any command or way to find out what Active Directory Security
Group he belongs to or what database roles and server roles he posses on that
SQL Server Instance.