Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: integrating NT security into sql or access


Message #1 by "Bill Sisemore" <bsisemore@m...> on Sat, 26 Aug 2000 19:15:22 -0400
Please pardon my ignorance, but is there any way to integrate NT security 

with SQL or Access 2000 so that the "authenticated" user can see ONLY 

data that pertains to their username in a single database with records 

pertaining to many different users?



Thanks,



Bill S.





Message #2 by mkrishna - Internet Mail <mkrishna@c...> on Mon, 28 Aug 2000 09:18:41 -0400
hi bill,

U can do that by using ADSI.(know about it here

<http://www.asptoday.com/articles/19990310.htm>)



The moment a user logs into NT, you can capture his user name, and retrieve

only those records having this user name in the database. 

The Assumption here is the User_name in your database is same as the NT user

names.



good luck!!!

Murali





> -----Original Message-----

> From:	Bill Sisemore 

> Sent:	Saturday, August 26, 2000 7:15 PM

> To:	ASP Databases

> Subject:	[asp_databases] integrating NT security into sql or access

> 

> Please pardon my ignorance, but is there any way to integrate NT security 

> with SQL or Access 2000 so that the "authenticated" user can see ONLY 

> data that pertains to their username in a single database with records 

> pertaining to many different users?

> 

> Thanks,

> 

> Bill S.

> 

> 

> 


  Return to Index