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