OK.  This is where my ignorance will really show.  How do get the user id
from NT?  In other words, how do I set that variable?  I'm sure I'm just
missing something obvious.  My apologies.

Athelene

-----Original Message-----
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 14, 2000 11:30 AM
To: CF-Talk
Subject: Re: Newbie Security Question


You could save their NT user ID in a session variable and refer to that
everytime you want to run a query.

Kevin Schmidt
Internet Services Director
PWB Integrated Marketing and Communications
Office: 734.995.5000
Mobile: 734.649.4843

----- Original Message -----
From: "Gieseman, Athelene" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 14, 2000 9:41 AM
Subject: Newbie Security Question


> I've been watching this list for a while and reading what I can find.  Yet
> I'm still stuck.  Please tell me if I've missed something.  I have an
> application where I want the user to see only those sql records (using MS
> SQL 7.0) where a certain field is equivalent to their NT user id.  It
seems
> from what I've seen that it either can't be done or I may need some other
> component to make that happen.  Is there a way to evaluate what the NT
user
> id is?  I don't need to validate their password.  Once they've logged in I
> can assume they are that user.  So all I really need is to be able to
write
> a query that would select only the records where the field USERNAMEFIELD
EQ
> #this is what I'm missing#.  Can someone point me to a resource for
figuring
> this out?  TIA.
>
> Athelene Gieseman
> [EMAIL PROTECTED]
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to