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 cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---