Re: SQL Server Enterprise Manager unwanted feature

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/31/02


From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 31 Jul 2002 08:52:31 -0600


The user can't access the other databases, logins but can
see them in Enterprise Manager. It's just the default
behavior of Enterprise Manager.
People often ask that this be changed - you may want to
submit the request to: sqlwish@microsoft.com

-Sue

On Wed, 31 Jul 2002 07:28:10 -0700, "T" <th@excellence.net>
wrote:

>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: 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: Users not visible in databases user folder
    ... Are you member of sysadmin server role? ... > I use enterprise manager for my SQL-Server databases. ... > I can no longer see my users listed in any of my databases' user folders. ... > permissions - everything looks in order. ...
    (microsoft.public.sqlserver.security)
  • 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
    ... Enterprise Manager uses the SA ... Hiding MS SQL databases in Enterprise Manager ... The server in question is currently Microsoft SQL Server 7, ... Network with over 10,000 of the brightest minds in information security ...
    (Focus-Microsoft)
  • Users not visible in databases user folder
    ... I use enterprise manager for my SQL-Server databases. ... I got a new-used computer recently - our computer support folks tell me they ...
    (microsoft.public.sqlserver.security)