By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Windows NT Integrated Security

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
-----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?


Nov 12 '05 #2

P: n/a
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!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.