How do I hide databases in a SQL Server from External users 1

[BiancaJ]

I am going to give user rights for an external user to connect to my SQL Server via Client Network Utility.

Atlough I have given user permissions to only access one database and not the whole list, how do I make sure that they cannot see all the other databases on my SQL Server?

I have 20 instances of databases on my SQL Server and ideally I would like to give 20 different people access - but each of them when they enter my SQL Server, should not even know that the other databases exist.

Thanks.

 

[tlbroadbent]

What tool are you letting them use to access the server? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[BiancaJ]

Using the 'Client Network Utility' that comes with SQL Server.

Thanks,

Bianca

 

[tlbroadbent]

The Client Network Utility doesn't see databases. It only sets up access to servers. Wil the users have an application, MS Access, SQL Query Analyzer, SQL Enterprise Manager or something else to get to the the data? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[BiancaJ]

They will be using SQL Server as well. I am setting this up to allow replication between mine and their databases.

After I set it up through 'Client Network Utility', at the moment, I then go through the register server wizard to register their server and mine in each others SQL Server - is this what I am doing wrong?

Should I just connect eac other via the 'Client Network Utility' and they move directly to replication?

And through SQL Security - When I register the logins I only give access to the database they would need?

Thank you for your help

 

[tlbroadbent]

Register Server Wizard is in the Enterprise Manager. If the users have Enterprise Manager, I don't think you can hide databases from them. They won't be able to read or update but will still see the databases. Typically, users shouldn't have Enterprise Manager.

Hopefully, Microsoft will correct this shortcoming in future versions of SQL Server. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.