Re: Permissions!

From: Arpan (arpan_de_at_hotmail.com)
Date: 09/05/05 

Date: 5 Sep 2005 13:30:17 -0700

Sorry Dan.....forgot to ask another question.

Assume that instead of 3 users, there are, say, 100 users. Does that
mean that 100 views have to be created - one for each user? If yes,
then this means that the ASP application that will be accessing the
columns must have 100 If....Else statements with the ConnectionString
having different UIDs & Passwords something like this (assuming that
each user has to enter a password in the ASP application first before
proceeding further):

----------------------------------------
Dim strPassword
strPassword=Request.Form("pwd") 'collecting the password the user has
entered

If(strPassword="pwd1") Then
"Provider=SQLOLEDB;Server=(local);Database=ARPAN;UID=uid1;PWD=pass1­"
ElseIf(strPassword="pwd2") Then
"Provider=SQLOLEDB;Server=(local);Database=ARPAN;UID=uid2;PWD=pass2"
ElseIf(strPassword="pwd3") Then
"Provider=SQLOLEDB;Server=(local);Database=ARPAN;UID=uid3;PWD=pass3"
................
................
................
End If
----------------------------------------

This will be a tedious & monotonous approach! Would you suggest some
other workaround to this?

Also the ConnectionString that uses 'Integrated Security=SSPI' doesn't
include any UserID & Password; so how will SQL Server know which user
is trying to access data & restrict data access accordingly?

Thanks once again,

Regards,

Arpan

Relevant Pages

  • Re: Permissions!
    ... Your suggestions have indeed been very helpful, Dan. ... I tried using the ConnectionString you have cited in an ASP application ... can access the different views & play with the records by viewing the ...
    (microsoft.public.sqlserver.security)
  • Re: Zugriff auf SQL-Server
    ... Schau dir mal den Connectionstring im Quellcode an. ... InitializeComponent eingetragen wird und die standardmäßig nicht ... MS MVP für ASP / ASP.Net ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • Re: Datenbankabfrage mit VS.net + web.config
    ... die den ConnectionString aus der web.config verwendet? ... nur über einen appSettings-Eintrag. ... MS MVP ASP / ASP.NET, ... http://asp.net-codebook.de - ASP.NET Codebook ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • Re: Problem mit MySQL-Dataprovider (ByteFX)
    ... Wenn ich aber einen Connectionstring erstellen ... Der Objektverweis wurde nicht auf eine Objektinstanz ... MS MVP für ASP / ASP.Net ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)