Retricting outside access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stranger - 30 Sep 2005 22:47 GMT

Hello,

We currently have a database that is in development using MSDE and being
hosted at the delopers site (Front end is in Access). Clients currently
access the database via IP.

We are planning on bringing this in house and using sql server. Just got
it.

Now, how can I give the deloper full access to the database? My thinking is
that giving them VPN into the network and then setup a DSN/DSN less
connection that allows them full access to the specific database but not to
any of the other databases within SQL server. Is this correct? If so, how
would I accomplish this?

Thanks

Reply to this Message

MeanOldDBA - 01 Oct 2005 06:28 GMT

If you are going to use VPN, which I would recommend (secure VPN if
available), then you can have them authenticate as an AD user to the SQL
Server. Setup their AD user account in SQL Server with whatever access
(database roles, server roles, etc) you want them to have.

Signature

MeanOldDBA
derrickleggett@hotmail.com
http://weblogs.sqlteam.com/derrickl

When life gives you a lemon, fire the DBA.

> Hello,
>
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message