Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2002
    Posts
    19

    Thumbs up Unanswered: How to prevent displaying all names of databases?

    I get an issue, that is: Once i expand databases from SQL Enterprise Manager, it takes a long time to wait displaying all names of databases. How should i do to prevent displaying all names of databases?
    Last edited by bruce_nguyen; 05-15-04 at 07:05.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Connect as a login that only has access to the selected databases. SQL-DMO (the tool that underlies SQL Enterprise Mangler) will only enumerate the databases you can access in some way.

    -PatP

  3. #3
    Join Date
    Nov 2002
    Posts
    19

    Wink I will try

    Thanks for your valueable advance. I'll try it. Can you tell me some clearly?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Sure. I'm not going into step-by-step details, but I can also do that if you'd like.

    1) Create a new SQL login.
    2) Give it access to only 3 or 4 databases.
    3) Open SQL Enterprise Manager
    4) Find the server of interest
    5) Right click on the server name
    6) Select 'Edit the SQL Server Registration Properties' from the popup menu
    7) Change the login and password

    When you connect to the server, SQL-DMO will only enumerate the databases your new login can use.

    -PatP

  5. #5
    Join Date
    Nov 2002
    Posts
    19

    Smile I still wonder...

    PatP, can i manual on server-side mssql but not client-side? I don't want my clients to know them

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you make separate logins for each client, and only give those logins access to the databases that you want them to see, then those databases (plus a few system databases like master and msdb) are all that those logins will see.

    -PatP

  7. #7
    Join Date
    Nov 2002
    Posts
    19

    Smile Do you understand?

    PatP, ofcourse the clients can't access other databases but, but, They still can see a list those.

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Well I'll be jiggered! You are right, the logins can see databases that they aren't authorized to access. I'll have to find out why that changed, but that's the only way I knew to limit the databases displayed.

    Sorry.

    -PatP

Posting Permissions

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