How to work on Custom Authorization in MVC

See more:

MVC

Hi,

In my MVC Application I want to work on Custom Authorization Attribute. The Scenario is,
I am having a users Table with the Roles like "Admin","Support Engineer" and "Users". In my another table I am having the roles for the users like "Team Lead", "Developer", "Group Head" etc.
Now in my custom Authorization method I need to check whether the logged in user has the role of user, If yes then I want to check the role of that user in another table and I want to give the Access permission to the user for Accessing that page. How to do this one can any one help me to do this method.

Thanks