I would like to manage access control of my users, and allow each role different pages within the website. Each user, might also have different rows.
I would like to know what is the best way to handle this access control. However, I have these limitations. The roles are created on an Oracle database which I am using and I am not to use the ASPNETDB in the APP_DATA to manage the roles.
My initial idea was to veryify the access of the user and create a session to state whether he is an admin, a user, or both. However, I still needed to figure a way how to hide/show menu items accordingly. I did not proceed with this idea because I believe asp.NET 4.0 would have something ready built for this use.
Update: I am using Web Forms
Update #2: I am not using a login form. I am retrieving the windows username of the person logged in and comparing it with the access of that username in the database. The authentication mechanism is manual, just need to find out how to distinguish between roles and how to show different menus.