SQL Address

[dynamota]

Hi All,

We have an MS SQL server that is within the company firewall. We want a
particular database to be availabe to a vendor to build a website.

When we had to develop a website on another vendors machine they gave
us following details.

SQL Address: testdata.data.c om
SQL Port: 1234
SQL testUsr Password: testPassword

1. How do we go about doing this?

*******

The SQL Server has 5 other databses. I have already created a database
user for just that database.

2. So If the vendor registers their enterprise manager with our
information, can I make them see only their database? Or does all the
other database also get displayed. They are not able to access any
information on the other databases. But they can see it.

Is it possible to prevent them from seeing the other databases?



Tx in advance

[serge]

Re: SQL Address

Is it possible to prevent them from seeing the other databases?

As far as I know the answer is No. They will be able to see the other
database names but should not be able to see any of the databases'
objects if you've given them an SQL login who has access only to
their specific database.