www.webdeveloper.com
Results 1 to 6 of 6

Thread: Read-access for public or for dynamic IP?

  1. #1
    Join Date
    Apr 2011
    Location
    Seattle, WA
    Posts
    265

    Exclamation Read-access for public or for dynamic IP?

    We work with a company that wants to host some of our listings on their website, but we use a database and they don't have a "dedicated IP" like we do, so I can't just put their IP in the "safe" list...

    Is there some way to allow them read-access to our database?

  2. #2
    Join Date
    Mar 2006
    Location
    Discworld
    Posts
    75
    Just create user in security with read only access to that specific database.
    MS SQL have variety of different levels to choose from.

  3. #3
    Join Date
    Jan 2007
    Location
    Wisconsin
    Posts
    2,120
    In general, you want to avoid allowing database connections from any IP address. Build a simple web service or page to relay the needed records in a JSON, XML, or CSV format, over SSL, if desired, and contingent on some agreed upon access key (or "password").
    Jon Wire

    thepointless.com | rounded corner generator

    I agree with Apple. Flash is just terrible.

    Use CODE tags!

  4. #4
    Join Date
    Mar 2006
    Location
    Discworld
    Posts
    75
    There is a third option:
    If your network admin familiar with VPN you can allow them authorized access to your database via VPN connection.
    And yet you will need specific user with read only access.
    Because even over super secure connection you do not want anyone connect to your database server and mess with unintended data.
    But if they need just to read data to show on their site why not give them something like JavaScript widget hosted on your site to display your data?
    Or that can be achieved by web service to throw all data in XML format at authorized request...
    Last edited by alexsts; 06-05-2012 at 03:26 PM.

    Please consider the
    environment before printing

  5. #5
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,427
    Quote Originally Posted by alexsts View Post
    There is a third option:
    If your network admin familiar with VPN you can allow them authorized access to your database via VPN connection.
    And yet you will need specific user with read only access.
    Because even over super secure connection you do not want anyone connect to your database server and mess with unintended data.
    Unless you're a developer telecommuting from home over VPN. (Okay, excuse me while I get back to work... )
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  6. #6
    Join Date
    Mar 2006
    Location
    Discworld
    Posts
    75
    NogDog is correct, VPN access is for developers not for displaying your content on someone site.

    Please consider the
    environment before printing

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles