MySQL Forums
Forum List  »  Stored Procedures

Re: reun stored procedures on dedicated server
Posted by: Peter Brawley
Date: May 09, 2013 11:15AM

> creating an application in which a new database get created for every user

A first principle of database design is to minimise redundancy. Creating a near-identical database for each user is the exact opposite of that. It's almost always a major design mistake.

Multiple users are nearly always best managed by a properly designed users table in conjunction with appropriate privilege management. Lots of web articles on the subject--consider studying a few of them before you proceed.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: reun stored procedures on dedicated server
917
May 09, 2013 11:15AM


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.