Windows NT Integrated Security

[Dave]

I have an ADP application that uses Windows NT Integrated Security.
Is there a way that I can programmatically check to see if a user is a
member of a certain group?

or...if Not

Is there a way in the same application to see if the group that the
user is a member of is a member of a certain Role in the database?

Thanks for your time.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Read the BOL article on "sp_helpuser." It will return all info about
a user:

exec sp_helpuser 'dave'

Where 'dave' is the NT or SQL sign-on name.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQEFsyYechKqOuFEgEQKT/ACgzQosVsZKSCJLTulV+aQUS6eU5UoAoIJL
0v7sBdsvLJfHi+n4NHp5doI8
=K70g
-----END PGP SIGNATURE-----
Dave wrote:

I have an ADP application that uses Windows NT Integrated Security.
Is there a way that I can programmatically check to see if a user is a
member of a certain group?

or...if Not

Is there a way in the same application to see if the group that the
user is a member of is a member of a certain Role in the database?

[Dave Burkett]

Thanks for your reply. I tried your suggestion, but it doesn't quite
satisfy my problem. My users are defined in a Windows User Group. It
won't tell me if a user is a member of an authorized group.

My dilemma is that I need to be able to allow Users to delete their own
records and not others, but someone that's a member of the CFAdmin can
override and delete the record.

I'll use VB to check if the record is theirs so that they can delete it.
That's no problem. It's just the check to find out if another person is
part of the CFAdmin Group.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!