Re: Application Security

From: John Bell (jrm_bell@hotmail.com)
Date: 12/29/02 

From: "John Bell" <jrm_bell@hotmail.com>
Date: Sun, 29 Dec 2002 14:13:59 -0000

Hi

I think you need the IS_MEMBER function to check the user is a member of a
given group/role, the implementation is probably very similar to you
existing method.

If you use server roles then use IS_SRVROLEMEMBER.

John

"paul reed" <prreed@jacksonreed.com> wrote in message
news:#cf3PovrCHA.2260@TK2MSFTNGP10...
> 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
>
>