SQL-server with ASP

[Ludo VdB]

Hi,

I'm new to ASP. Currently I'm planning to develop a web application for my
company. I want to use ASP for the application and use SQL-server as the
back-end.

I want to enable a userID and password for every user. I also want to
specify permissions to parts of the application.

I have 2 scenario's for this:

I let the application handle the permissions to the different parts. I keep
the permissions in a table in the database so the application knows witch
user has access to witch part of the application. therefore I will only need
one connection to the DB.

I let the permissions handle thru the DB. The application passes through
password and userID to the DB. For every user who logons to the application,
the application will have a connection to the DB.

What's the best scenario?
Or witch scenario should I use when?



Ludo

 

[Guest]

both scenarios sound the same in functionality as well as in db connection practice.

dimitris

 

[Kevin Spencer]

ASP questions should be posted to the
microsoft.public.inetserver.asp.general or the
microsoft.public.inetserver.asp.db newsgroups.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.