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]
