Application Role

From: David Crone (david.crone_at_currieb.ie)
Date: 06/08/05 

Date: Wed, 08 Jun 2005 04:56:51 -0700

Hi there

I have a VB.NET application, that is accessing a SQL DB. I would like to
set it up to start using Application Roles, but am getting some strange
results, and would appreciate advice regarding Best Practices.

My VB.NET application is using SQL Helper class, which basically seems
to be using Connection Pooling, and creating a new connection for each
transaction (if none in the pool). I dont want to set the APplication
Role to be activated in every single call to the DB, as this will slow
down the application completely, but I would like to somehow implement
an Application Role.

I know that Application Roles dont use Connection Pooling, and I dont
mind the preformance hit there, as the application is mostly
single-user.

Also, does anyone know - if I set up an Application Role, can Any
application that has the ApplicationRole password get in and Activate
the Role, or is there a way to limit it somehow?

Thanks in advance
David Crone

*** Sent via Developersdex http://www.developersdex.com ***

Relevant Pages

  • Re: SQL express performens lagg
    ... for 1 client app wich is running on it self... ... as i also said b4 i have tryed other SQL servers with smaler footprint... ... fastes i could get my hans on if i dont want any Fans! ... XPe image incl Express takes op 250Mb og the hdd and starts in aboudt 13 sec ...
    (microsoft.public.sqlserver)
  • Re: connection options to yukon
    ... Connection pooling depends on the fact that repeated SqlConnection objects ... My recommendation would be to use Windows authentication over sql Auth ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to SELECT records based upon ASP.NET Roles
    ... connection pooling will work better than if a large ... as a SQL Login.) ... Row level permissions is kind a complicated topic to be implemented ... Since you can't pass parameters to views, you'll restrict the ...
    (microsoft.public.dotnet.security)
  • Re: VB with SQL Server... Unable to create temp table using ADO connection object
    ... > I am not using connection pooling. ... SQL Server MVP ... but when I query the temp table either in VB or in SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: Encryption of application configuration block
    ... access to Sql Server objects based on the current users' Windows account. ... This would potentially help (although I still don't like potential hackers ... connection pooling kicks in for the whole domain. ...
    (microsoft.public.dotnet.general)