Post reply

Restrict view in Enterprise Manager

  • June 1, 2005 at 8:13 am

    #86883

    How do you make sure a specific user can only see the database he has access to in Enterprise Manager

     

    By default the specific user can see a list of databases on the server, even the ones he can't access.


    /SteenT

  • June 1, 2005 at 9:23 am

    #562226

    I am not sure that you can keep users from seeing database they don't have access to.  It would be nice if you could.  I just make sure the user has no rights to databases they shouldn't.

  • June 1, 2005 at 12:58 pm

    #562326

    You can't restrict this. Everybody who connects can issue a

    SELECT * FROM master..sysdatabases

    The reglementing factor here however is the access to the databases.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • June 2, 2005 at 3:15 am

    #562445

    The good news is that this can in fact be done and was covered here before.

    Please see:

    http://support.microsoft.com/default.aspx/kb/889696

    Despite the topic of the article it shows how to achieve what you want, although "SELECT * FROM master..sysdatabases" will still work.

    The SQL General

  • June 2, 2005 at 3:24 am

    #562451

    Thanks for the link. I need to keep that in mind.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply