MySQL Forums
Forum List  »  Security

Thousands of Companies' Info on a System
Posted by: K F
Date: April 29, 2010 06:02PM

I'm building a PHP app where a company has access to tables like these:
customers, events, vendors, products

The problem: How should I organize things if I want possibly thousands of companies to have access to that set of tables for their own company, but none of these companies should EVER be able to get access to another company's data?

I'm thinking:

* Each company gets its own database with its own set of tables

* Each company's database has is own unique username and password

* ???Somehow??? I'm able to let each company login into its database without storing its password in plaintext anywhere.

Options: ReplyQuote


Subject
Views
Written By
Posted
Thousands of Companies' Info on a System
3140
K F
April 29, 2010 06:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.