Re: Hiding database

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 18:41:17 -0000

Make sure they know about it by emailing sqlwish@microsoft.com
BTW - this is a common request but it never hurts to add a few more :-) 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeremy Collins" <jd.collins@ntlworld-not.com> wrote in message
news:zjL0c.16009$gC2.13472@newsfe5-gui.server.ntli.net...
> Sebastian K. Zaklada wrote:
>
> >>Can someone explan how to hide databases in enterprise manager.
> >>
> >>We have some users, which can manage only their databases.
> >>We want to hide ours.
> >>
> >>Thanks for any hint.
> >
> >
> > SQL Enterprise Manager does not allow you to do this, but why not revoke
the
> > rights for your database using permissions? You should set up
appropriate
> > accounts for your users then ensure that only the minimum required
> > permissions are granted to these users. See BOL for more information
about
> > granting/revoking certain user permissions.
>
> It's a shame you can't do this. I have the same problem from
> a client perspective - whenever I connect to my hosting company
> via EM, I get a list of about 400 databases, even though I only
> have access rights to one of them.
>
> It's a bit of a pain!
>
> -- 
> jc
>
> Remove the -not from email

Relevant Pages

  • Re: Configuring SQL 2000 for use with ESRI ArcSDE
    ... You can assign SQL Server users to database roles using sp_addrolemember: ... Permissions are entirely application specific. ... vendor for clarification of security requirements. ... I have Two databases 3 Roles ...
    (microsoft.public.sqlserver.server)
  • Re: Permission to restore databases and access them without being
    ... dbcreator to the login so that you can restore the databases. ... " in SQL Server 2005 Books Online: ... assign your wanted permissions such as db_reader/db_writer ...
    (microsoft.public.sqlserver.security)
  • Re: Security Script
    ... You when you restore a database, or attach it, SQL Server maintains the ... logins but removes all permissions to databases and their objects. ...
    (microsoft.public.sqlserver.security)
  • Implementing Data Warehouse
    ... We have one SQL Server 2000 with several different databases from 3rd party ... procedures, etc) from OUR custom database called LEITER, on the same SQL ... permissions are guaranteed to work. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: public role???
    ... What exactly do you mean by "new users have access to all DBs"? ... If you mean that new users can see the names of the other databases, ... Documentation on the "guest" account is available in the SQL Server Books ... > permissions. ...
    (microsoft.public.sqlserver.security)