How to restrict access our DB on SQL server.

From: paresh goyal via SQLMonster.com (forum_at_SQLMonster.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 12:49:45 GMT

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

  • SQL Server Client bad Performance
    ... I have an issue when I use both SQL Query Analyzer and Enterprise Manager. ... At Enterprise Manager level, it lasts about 1 minute when I connect to server. ... My collegues that use the same databases on the same server don't have any problem then I assume that this is a client problem inside my PC. ...
    (microsoft.public.sqlserver.connect)
  • Re: Adding User to Standard Role
    ... May also test if the user can select from the table via other applications, ... such as SQL query analyzer. ... then Crystal Report settings may need ... For information about the Strategic Technology Protection ...
    (microsoft.public.sqlserver.security)
  • SQL Query Analyzer cannot bring up all the database in Object Brow
    ... when using the enterprise Manager, I can read 12 database. ... But when I use the SQL Query Analyzer, I can only read 6 DB. ... Master, Model, Msdb, Tempdb, Northwind and pubs. ...
    (microsoft.public.sqlserver.tools)
  • Re: Output column with no carriage return
    ... (Reverse address to reply.) ... > I am using SQL Query analyzer to produce output that I am copying to ... > like to see is the data pasting into Excel as one row. ...
    (microsoft.public.sqlserver.programming)
  • Output column with no carriage return
    ... I am using SQL Query analyzer to produce output that I am copying to excel. ... One of the columns displays the output with carriage returns. ... like to see is the data pasting into Excel as one row. ...
    (microsoft.public.sqlserver.programming)