Need help with remote database access solution

Discussion in 'Databases' started by the_gamestas, Feb 20, 2007.

  1. #1
    Hi guys,
    I'm trying to find a solution to a problem a company I'm working for is having. They want customers to be able to search a limited section of a database (with limitations tailored to each customer) from a remote web portal. What is the best solution for this sort of problem?
     
    the_gamestas, Feb 20, 2007 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,908
    Likes Received:
    4,555
    Best Answers:
    124
    Trophy Points:
    665
    #2
    Create a login, and then link the users to the company they represent. Then link the information in your database to the appropriate company.

    How you create the user system depends on the system you have written the website in. From your 3 line into I'd recommend cakePHP but realistically I'd need a whole lot more info first.
     
    sarahk, Feb 20, 2007 IP
  3. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Many ways to do this. If you provide more information about your portal platform you will get more accurate answers.

    If you want an point,click drag solution
    a.) Grab the login ID from the portal
    b.) Synchronize to SecurityDB in hkvstore.com/phpmaker or ASP or whatever
    c.) Create searh views in either Maker or Reporter
     
    sadcox66, Feb 22, 2007 IP