webapplication with SQL-server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ludo VdB (ict_at_vagga.be)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 14:22:42 +0200

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

Relevant Pages

  • Re: SQL-server with ASP
    ... ASP questions should be posted to the ... > I let the application handle the permissions to the different parts. ... > user has access to witch part of the application. ... > Or witch scenario should I use when? ...
    (microsoft.public.dotnet.framework.aspnet)
  • SQL-server with ASP
    ... I'm new to ASP. ... I let the application handle the permissions to the different parts. ... user has access to witch part of the application. ... Or witch scenario should I use when? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FolderExists and UNC path
    ... Traditionally ASP uses the IUSR_account so try mapping a drive using that username and password or assigning permissions to that account or changing to a different one if you don't know or can't change the password. ... When I ran this command from the server logged with my user it ...
    (microsoft.public.scripting.vbscript)
  • RE: Running vbs from WSH in ASP page
    ... I see a whole bunch of problems with the code sample you show (using wscript ... mapping, permissions, etc.) and I'm not the least bit proficient in ASP. ... > When I run the vbs from the command line all is well. ...
    (microsoft.public.scripting.wsh)
  • Re: Access97 DB locks up the asp code at times
    ... of these users created the query off the asp and that's the problem. ... but I could never see the employee.ldb on the folder ... I'll chat with our IT group about setting the proper permissions. ... All database users, including the IUSR_MachineName account, need ...
    (microsoft.public.inetserver.asp.general)