|
 |
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.
>
>
>
|
|
 |