Application Security

From: paul reed (prreed@jacksonreed.com)
Date: 12/29/02 

From: "paul reed" <prreed@jacksonreed.com>
Date: Sat, 28 Dec 2002 21:19:38 -0800

I would like to custom load the various ASP pages a user can have access to
based on the role they are playing. The only way I have done this before is
to build my one role/user/function tables and then at login, determine their
role and then load the menus accordingly. Someone recently suggested I use
role security in SQL Server...I am not sure how I can get the same
functionality I need.

I am using VB.NET and SQLServer 2000.

Thanks,

Paul