Re: SQL Logons and password
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 25 Jun 2007 22:20:59 +0000 (UTC)
Simon (Simon@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
However for various reasons I am unable at this point to change the
password to a sysadmin role on a main server. I need to secure this
somehow. Is there any way I can force a login to only work when called
from an application or from ODBC but not when a user uses it via SQL
tools ? I`m sure the answer is no but just thought I`d ask.
There are application roles, which the application can set. But it needs
a password, and if the application is a two-hier app, you can't hide the
password, just make it hard to find. But an applicaiton role is a database-
only entity, so if the application needs privs on application level, they
are out anyway.
And there is no way you can configure this on server level.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: No selections in Proxy List (SQL 2005)
- Next by Date: What are the Roles of Production DBA?
- Previous by thread: Re: No selections in Proxy List (SQL 2005)
- Next by thread: What are the Roles of Production DBA?
- Index(es):
Relevant Pages
|
