I am working on a project which will involve (hopefully *crosses fingers) multiple clients logging on to my site to perform CRUD operations on a MySQL database. Each client will be able to update new information as needed to the database through a GUI.
I plan on writing a PHP script to create the necessary tables for each specific client. EX:
Client A will have Users_A, First_Name_A, Last_Name_A, Address_A
Client B will have Users_B, First_Name_B, Last_Name_B, Address_B
etc etc etc...
Should I create one database connection that handles all the queries of every client or should I create a unique username for each client and restrict access to the other databases? Am I vulnerable to attacks if I just use one login/pass to handle everything?