Farrukh,

Use "sp_helplogins" for logins and "sp_helpuser" for users in a database.
Both will reports on role memberships.

Then, if you need more details on securables granted to a user or a role,
use "sp_helprotect".

Look up the parameters in the Books Online.

RLF