Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    1

    Unanswered: Need Help in Database creation

    Hi Experts,
    I am indulged in developing Online Issue Tracking sytem.For that I have met with a problem in Database creation.

    The Sceneario is "The Database should be specific for each and every group of customers,For example initially A is a company with 10 users accessing the product after two days B is a company with 50 user accessing the same product.In this case the datase base should be provided to the two person separately at the moment when they register the product for 10 users and 50 users.How to handle this.

    Any sort of ideas is valuable for me.
    Thanks,
    Ramanan

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Will each company have their OWN database residing on the same server?

    use role-based logon access, and grant CompanyB access to users from Company B, and CompanyA access to users from Company A.

    Ref the postgresql manual...to get you started.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    May 2005
    Location
    San Antonio, Texas
    Posts
    134
    hmmm.. that is a bit confusing

    It sounds like to me the DB part of the 'product' and he wants to allow companies with users to sign up and use it.

    You could just create an account table which is for the company that allows access to 'the product' and each company can have a set of users. If that is what you mean
    Vi veri veniversum vivus vici
    By the power of truth, I, a living man, have conquered the universe

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    As you say, if a single database is to be used, then you'll also want to control direct access to underlying tables, by using views & rules
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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