Re: Integrated Security
From: Russell Fields (rlfields_at_sprynet.com)
Date: 07/18/03
- Previous message: Russell Fields: "Re: Ownership chain"
- In reply to: Dave Havard: "Integrated Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 18 Jul 2003 16:42:00 -0400
Dave,
Have you tried using the IS_MEMBER and IS_SRVROLEMEMBER functions in TSQL?
These will not enumerate the groups that a login is a member of, but you can
check for membership in any group that you are concerned with.
Russell Fields
"Dave Havard" <dave@exploreworldwide.com> wrote in message
news:0dd501c34d34$9c579710$a401280a@phx.gbl...
> Hi
>
> I am trying to impliment some security based on wether a
> user belongs to a particular Domain Group. I have added
> the group as a login to SQL (2k) and am using the
> xp_logininfo extended sp to get a check wether the
> connected user is a member of that group. The problem is
> that when I add more groups the procedure does not detect
> them. Is there something I need to do?
>
> Thanks
> Dave
- Previous message: Russell Fields: "Re: Ownership chain"
- In reply to: Dave Havard: "Integrated Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
