XXBOUSTERXX
New Member
I want to create a User Management, and I need each user to have it's own Tables with their own Structure. I currently just built a script that will create a new DB for that user, and allow them to create as many tables within (each one of their 'projects' is a table).I know that this is not the most efficient way to manage users. I have a User table, which stores their Database table name, so everything is managed through that. (scripts to delete the user, user db, user tables. Same for Adding new users).I guess i'm looking for insight on this method, or if i should just create a MASSIVE users_table, and have their UserID prepend their table names (i.e 1001_tab1, 1001_tab2, 1002_tab1, etc).Tried searching for this topic, found some related but not exact. No need for code examples, just looking for advice and insight on this method. Thanks again.