I have a few questions for those of you who offer MSSQL Databases.

How to you give access to your users? Do you allow them to use Enterprise Manager to connect to their databases? If you do how do you prevent them from seeing all the other databases on the server?

As far as I know when you give a user access to only one DB they still see all the other databases there even though they cannot access them.

Many thanx

Originally posted by delirium
If you do how do you prevent them from seeing all the other databases on the server?

As far as I know when you give a user access to only one DB they still see all the other databases there even though they cannot access them.


There is no way to filter out other databases using enterprise manager at this time. You will always be able to see all other databases. The only thing a host can do is use cryptic names or account numbers to stop other users from knowing what site the other databases belong to.

Originally posted by ACW
There is no way to filter out other databases using enterprise manager at this time. You will always be able to see all other databases. The only thing a host can do is use cryptic names or account numbers to stop other users from knowing what site the other databases belong to.

Thank you for your response, This is exactly what I was planning on doing but just checking that I was not missing something obvious ;)

Thanx again.

glad to help!:)

Make sure you don't grant access to the "public" role otherwise everyone with access to the box will be able to see the database contents :-)

Originally posted by monaghan
Make sure you don't grant access to the "public" role otherwise everyone with access to the box will be able to see the database contents :-)

HAHA ;) I know that much but thats for the headsup - I have been using SQL since 98 so have a good understanding of SQL, I just wondered what other hosts did when hosting shared SQL servers.

Looks like the best route is the anonymous database names...