Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    California
    Posts
    18

    Unanswered: How not to display all databases under sql2k using sql management studio?

    When you use sql 2005 management studio to connect to a sql 2005 server, you can deny view on any database and one user will not be able to see any database that he/she does not own.

    However, what about if this person uses sql 2005 management studio to connect to a sql 2000 server. Since sql 2005 management studio does not call the store procedure sp_MSdbuseraccess, it will display all the database in the server.

    It does not seem like I can use "deny view on any database to username" on a sql 2000 server.

    Does anyone have any idea what I need to do in order to not show all the database when I use sql 2005 management studio to connect to a sql 2000 server box?

    Thank you.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    EM will show the database as existing, but you can still deny access to the database and prevent people from opening it up or viewing the objects and data inside it.

    Only admins should be using Enterprise Manager anyway...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2003
    Location
    California
    Posts
    18
    What I want to do is to deny any login id (who owns certain database) to not be able to see other database at all.

    Just like sql 2005, you can run "deny view any database to userid"

    However, doesn't seem like sql 2000 has this command.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The databases are like houses. You can prevent people from going inside, but you can't prevent people from seeing them.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •