The following is a boiled down version of what I want to provide. I'd
appreciate any ideas. I believe views would be idea, but as mysql
doesn't have views I'm looking for a work-around.
I have a table that consists of an id and a text field like so:
ID TEXT
2 sample text for group 2
2 more sample text for group 2
3 sample text for group 3
3 more sample text for group 3
I have another table listing usernames and "groups" they have access to
like so:
USERNAME GROUPS
bob 2
frank 3
cindy 2,3
roger
I want to be able to provide each user access to only the groups
specified for him/her. The appropriate data needs to be available to
each user connecting to the database remotely. Most likely users would
use myodbc on a windows box to access their data (it need only be
readable).
I imagine views would be ideal to solve this problem: I would only give
each user access to a view, and it would form the visible data. The
only thing I've thought of that can simulate this is to form a separate
table (or database) for each user, and when the data table is updated,
each users table is updated as well, as appropriate. This seems like an
awful solution, especially as the number of users grows.
Any suggestions?
Eric Mayers
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
