Newbie question

From: RD (nospam_at_nospam.net)
Date: 05/14/05 

Date: Sat, 14 May 2005 12:01:06 -0400

I have a login which does a lookup in a Sql server table to check for valid
usernames and password. Then if login is Ok user allowed to go to next page
by using a response.redirect. Once on the next page he can continue using
site.

Question is how do I prevent a user from copying a URL from the explorer and
copying that address to a browser and then go directly to that page,
bypassing the login page?

I need to use SQL server based login because it is easier for the users to
maintain that list with a simple User Interface than it is to have them
understand the ins and outs of Windows security and groups. most of my
customers are small buisnesses with no budgets for training or hiring system
admins so I gotta KISS - (keep it simple stupid) :-)

Thanks for any help

RD

Relevant Pages

  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)