Grant permissions to role on another role

[Danzy83]

Hi all! I would like to know the SQL that can grant select on a Database Role to another role. I want members of one role to view and see members in another role so thet the first role can select members from the second role. I don't know how to do this. Please help.

[coded007]

you can create login groups and grant permissions. For Granting permissions please check below link http://msdn.microsoft.com/en-us/library/ms186717.aspx[^]

Mani Prabhakar