i think you have created user/login in sql server to provide access to set
of objects (giving read/exec permissions right).
but do that only if your functionality demands. in this case you will not be
utilizing benefits of connection pooling.
use only one identity to connect to sql server.
Av.
"chris" <anonymous@discussions.microsoft.com> wrote in message
news:A866CBB1-1BFA-4A57-B263-3DDCB6BE9A75@microsoft.com...
> Hi,
> I am working on an intranet application. I am using windows integrated
> authentication. Now since the authentication is done by active directory
> can I use a specified user name and password in my connection string and
> not SSPI? You see I created a user/login in sql server with minimum
> privledges.
>
> Thanks
Re: Permission at the row level associated with user/login ...Juan Dent writes: ... particular rows to a user/login while another user/login can see the other ... Is this granularity level possible in SQL Server 2005? ...Books Online for SQL Server 2005 at ... (microsoft.public.sqlserver.security)
Re: Permission at the row level associated with user/login ... I have the following scenario:... particular rows to a user/login while another user/login can see the other ... Is this granularity level possible in SQL Server 2005? ...Juan Dent, M.Sc. ... (microsoft.public.sqlserver.security)
Re: Windows Authentication in asp.net 2005 to SQL Server? ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server.... (microsoft.public.dotnet.framework.aspnet.security)
Re: I dont want to re-invent the Login/Login Wheel - Help with utilities ... Yes, if you use .NET1.1, there isn't built-in login control, and more importanltly there isn't ready-to-use membership component to use. ... the membership provider uses SQL Server or SQL Server Express. ... We feel that having the capability to force password change would be a better benefit in securing our application and data access. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ... (microsoft.public.vstudio.general)
RE: IIS (ASP) -> SQLServer Authentication Issue ... I understand that you'd like to use IIS Intergration authentication in the ... and ASP "impersonates" authencitaed users to access SQL Server on ... only kerberos authentication allows double-hops from clients ... (microsoft.public.sqlserver.security)
