I'm converting a vb.net 2005 desktop application to being web based. The user would log into a server using remote desktop connection.
Anyone who could log into the server could start the GUI, but when a user wanted to do more than read information the GUI called a stored procedure called GetPermissions to see if they were allowed to do what they wanted. The procedure was something like this.
select is_member('part1') as part1,
is_member('part2') as part2,
is_member('part3') as part3,
is_member('part4') as part4,...
some users have permission to execute part1, others part 3 others have permission to execute all parts.
How best to replicate this set up in a web based GUI (asp.net 3.5 with vb)?
One big difference is that the link should only work for people who have permission to use at least one of the four parts mentioned above.
If I use a login control I'm worried I would have to somehow manually synchronise the ASP.net roles with the db roles.