Re: Permissions!

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

Date: 5 Sep 2005 12:46:33 -0700

Your suggestions have indeed been very helpful, Dan. Thanks for the
same.

I tried using the ConnectionString you have cited in an ASP application
but it throws the following error:

-----------------------------------------
Login failed for user 'ARPAN\IUSR_ARPAN'.
-----------------------------------------

Why this error?

There's another question I would like to ask you regarding Permissions
in SQL Server. After executing the queries you had provided, I am now
able to restrict users' access to the different columns but any user
can access the different views & play with the records by viewing the
records in Enterprise Manager. Is there any way to overcome this?

BTW, what is IMHO?

Thanks once again,

Regards,

Arpan

Relevant Pages

  • Re: Permissions!
    ... each user has to enter a password in the ASP application first before ... 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? ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing ASP Intrinsic Objects
    ... "Dan Freeman" wrote: ... Infact it is the OCX that is doing ... The only work that the ASP is doing is to host the OCX. ... >>> user code). ...
    (microsoft.public.fox.programmer.exchange)
  • Re: asp scripts not running on windows 2003 server sp1
    ... "dan" wrote in message ... the extensions ASP in ASPX, ... Active Server Pages erreur 'ASP 0201' ... Le langage de script par défaut de cette application n'est pas valide. ...
    (microsoft.public.inetserver.iis.security)
  • Re: .asp pages not showing output from asp code
    ... I have the same problem Dan described. ... I looked at the MS link Dan ... I got to the DCOM Config but there was no VB ASP Debugging ... output from the HTML code appears in the browser. ...
    (microsoft.public.inetserver.iis)
  • Re: Accessing ASP Intrinsic Objects
    ... Dan ... Infact it is the OCX that is doing ... The only work that the ASP is doing is to host the OCX. ... this asp has an ocx control sitting on it (I did ...
    (microsoft.public.fox.programmer.exchange)