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