Re: How to restrict access our DB on SQL server.

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 09:03:29 -0500

Don't give out the passwords and they won't be able to login. If they have
a login and password then they can get in and do what ever the current
permissions allow them to. 

-- 
Andrew J. Kelly  SQL MVP
"paresh goyal via SQLMonster.com" <forum@SQLMonster.com> wrote in message 
news:d15479cc26b24cf0a782a131acead60a@SQLMonster.com...
> Hi,
> How can we restrict our DB if connecting thru other applications like SQL 
> query analyzer, Excel & even Enterprise manager?
> but this DB should be accessible by our application (from front end) 
> only...
> I learned about "Application Role" in SQL server 2000 but to apply this
> we will have to change our code thousand places.
>
> Have any idea...Pl. do suggest???
>
> Thanx in advance!!!!
>
> Regards,
> Paresh....
>
> -- 
> Message posted via http://www.sqlmonster.com

Relevant Pages