[PRamanan]

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

[loquin]

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...

• Managing Databases
• Database Roles and Privileges
• Client Authentication

to get you started.

[amthomas]

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

[loquin]

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