ASP ODBC Security in SQL 6.5

[Richard Coons]

I am in the process of writing an upgrade of a Database App at work. One of the functions of the App is to update a SQL 6.5 database. I was wanting to set the App up on our local Intranet. However due to my lack of knowledge I don’t know if ADO will enforce the securities that I have in place now. I have colum level restrictions based on Groups with useres in the groups. If I were to use NT access on the IIS4 server will ADO enforce the securties based on the User loged on????

Can anyone help please???

Thanks,
Richard Coons
BFI South East Texas Landfills
Richardz@neosoft.com

[Bob Wise]

Richard,

IIS4 uses the NT security. When you assign a login, in the ADO, IIS will
see that the specified user can only update certain columns and that will
be all that is allowed.

bob



------------
Richard Coons at 3/17/99 9:45:59 AM


I am in the process of writing an upgrade of a Database App at work. One of the functions of the App is to update a SQL 6.5 database. I was wanting to set the App up on our local Intranet. However due to my lack of knowledge I don’t know if ADO will enforce the securities that I have in place now. I have colum level restrictions based on Groups with useres in the groups. If I were to use NT access on the IIS4 server will ADO enforce the securties based on the User loged on????

Can anyone help please???

Thanks,
Richard Coons
BFI South East Texas Landfills
Richardz@neosoft.com

[tcronin]

If your are worried about the client's login it will depend on your authentication. Are you using challenge/response or basic text or neither. Your browser will also set whether or not you can even use this ty[e of IIS security. If it's IE great, if not basic/text with ssl might be a good choice


------------
Bob Wise at 3/18/99 8:09:41 AM

Richard,

IIS4 uses the NT security. When you assign a login, in the ADO, IIS will
see that the specified user can only update certain columns and that will
be all that is allowed.

bob



------------
Richard Coons at 3/17/99 9:45:59 AM


I am in the process of writing an upgrade of a Database App at work. One of the functions of the App is to update a SQL 6.5 database. I was wanting to set the App up on our local Intranet. However due to my lack of knowledge I don’t know if ADO will enforce the securities that I have in place now. I have colum level restrictions based on Groups with useres in the groups. If I were to use NT access on the IIS4 server will ADO enforce the securties based on the User loged on????

Can anyone help please???

Thanks,
Richard Coons
BFI South East Texas Landfills
Richardz@neosoft.com