Re: Hiding Databases in SQL Ent Manager

From: lindawie (lindawie@my-deja.com)
Date: 05/05/02 

From: "lindawie" <lindawie@my-deja.com>
Date: Sun, 5 May 2002 09:31:25 -0700

Lee,

> We allow SQL EM logins to our SQL server for those who have SQL DSNs.
> I would like to hide databases (names and all) from users without
> priviledges to enter the databases. Is there a way to do this?
>
> Alternately, is there another tool for a user to manage his/her SQL
> DB other than SQL EM?

You cannot hide user databases in Enterprise Manager. You could write
your own management tool using SQL-DMO or look for a third-party tool.

Linda

Relevant Pages

  • Re: How to check if SQL 2000 is installed? (SBS 2003 SP1 Problem!)
    ... > Enterprise manager" and view the databases running on your server (just ... > click the + until you see databases), then you definitely have a SQL ... But I have sometimes installed two Tools called "MSDE Manager" and "MS SQL ...
    (microsoft.public.windows.server.sbs)
  • RE: Hiding MS SQL databases in Enterprise Manager
    ... Using Enterprise Manager does not inheritly mean that the user ... called to get a list of databases that the user has access to. ... This command takes no permissions into account, ... didn't use that nasty chunk of ad hoc SQL to get the list of databases. ...
    (Focus-Microsoft)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)