I am creating an ASP page where I am trying to display controls on the page based on the roles of the user. I have a database wherein I have 5 tables to store the following:
Table 1: Application details having the app id as the primary key.
Table 2: Securtiy Roles, having the roles for particular WIndows Login id
Table 3: Security Users, having the details of the users with NT Login as the primary key
Table 4: Role Master table, having the roles available for the application with role id as the primary key
Table 5: Permissions table, having permission details for a role and for particular users for a particular application.
I want to know as to how I could create a role check and display the controls on a page as per the role.
Please help ASAP