Re: SQL Server Enterprise Manager unwanted feature

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 07/31/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Wed, 31 Jul 2002 10:41:29 -0400

There is no way to stop a user from seeing the other Db's in EM. If they
don't have permissions to the other DB's then they can't actually see any of
the data but they can still see the DB itself. There is no way at the
moment to change this. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"T" <th@excellence.net> wrote in message
news:317e01c2389e$7f070570$95e62ecf@tkmsftngxs02...
> Hi all,
>
> I've created a user with a single database permission.
> However this user, by using the Enterprise Manager, he can
> still view a list of all databases and worse view a list of
> all logins.  This is an unwanted feature that I would like
> to remove.
>
> Is there a way NOT allowing this single database permission
> to view within the Enterprise Manager?
>
>

Relevant Pages

  • Re: SQL Server Enterprise Manager unwanted feature
    ... The user can't access the other databases, logins but can ... see them in Enterprise Manager. ... >I've created a user with a single database permission. ...
    (microsoft.public.sqlserver.security)
  • SQL Server Enterprise Manager unwanted feature
    ... I've created a user with a single database permission. ... However this user, by using the Enterprise Manager, he can ... all logins. ... This is an unwanted feature that I would like ...
    (microsoft.public.sqlserver.security)
  • SQL Server Enterprise Manager unwanted feature
    ... I've created a user with a single database permission. ... However this user, by using the Enterprise Manager, he can ... all logins. ... This is an unwanted feature that I would like ...
    (microsoft.public.sqlserver.security)