Hi guys! I'm sorry if this is one of those questions that is
repeated but ... I must pose it :) .
I'm doing a database to support all of my companies activities,
for instance we have client information, order information, contacts,
suppliers, etc etc. Now, the structure is beginning to grow a little,
with Lookup tables and all, I'm heading for the 40 table mark. I can't
really know if this number is usual or even small, but I would rather
have things separated to improve my own organization.
Having said this my question is as follows: I would like to
organize tables under specific groups, for example, all issues related
to clients should go to a group named 'Clients' [original stuff here :)]
. As far as I can go, I can do this by putting these tables under a new
Database called 'Clients' but ... my issue is this, on my server I can
expect to have other databases not related to my company, and I would
like to be able to separate all these things so that I don't get a 200
database list every time I use 'Show databases'. What I want to know, is
how to tackle this, for instance, is there a way to define what
databases one user can see, so that he may only see his own databases.
I'm looking for theories, hope anyone has one :) Thanks in
advance guys...
David Ramalho
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
