If you use a client_id in the tables you could maybe add this filter in beforeFind in app_model ... just a hint.
On Jun 16, 2:33 pm, Mickiii <[EMAIL PROTECTED]> wrote: > Hi, > > I am in the process of building and specific business administration > system, where clients subscribe on the application. Initially I > planned on giving each client their own database, and then by > controlling on login, connecting each client to their individual > database. This has worked fine in development, but now I am a bit > confused about the logic in this. My reasoning for doing so was data > security, because that way I would make sure that each client only had > access to their specific database, but I wonder if this is a very > ineffective way of doing things, and I am considering going back to > the method of using one database with a client id seperating it. > My current method would mean that a single server should control > hundreds of databases. What is you oppinion on the best approach? > > If I decide to go with the client id approach, is it then possible to > make a global criteria to all queries in cake or should this be done > trough filtered views or similar? > > Thanks in advance for your attention and time on this. > > Regards, > > Michael --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
