if MySQL implemented db view objects.. then this functionality could be done.. Could create a view as select * from table where <condition> then grant a user access to the View, not the table so they can only get the filtered resultset. This is how some larger db systems, like Oracle do it.
I forget if mysql is planning on having db View objects anytime but until then, yes, you would have to control this in application code.. -- Brian Lindner Saturday, January 4, 2003, 5:44:19 PM, you wrote: > At 14:39 -0800 1/4/03, Steven Nakhla wrote: >>I know I can restrict a user's access to a table with >>the GRANT command. However, is there any way to >>restrict a user's access to individual rows within a >>table? > Not with MySQL's grant tables. You have to control this kind > of thing through application logic. >> For example, if I were using a SQL table to >>hold binary data (utilizing it like a filesystem, for >>example) could I restrict a user from reading or >>writing to or from certain rows within the table? Has >>anyone implemented something like this before and >>could give me some insight? Thanks much! >> >>Steve Nakhla > sql, query --------------------------------------------------------------------- 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