* raj > However, I wish to use this as a security tool. I.e. one in which I (as > the mysql admin) can do a grant like: > > "all queries on a specific table from user "apache" must only return > 1 record" > > This would be like forcing a limit of 1 (using the technique below).
I don't think GRANT can be used this way, but take a look at SQL_SELECT_LIMIT: <URL: http://www.mysql.com/doc/en/SET_OPTION.html > ...and also the --safe-updates parameter of the mysql client: <URL: http://www.mysql.com/doc/en/mysql.html > -- Roger --------------------------------------------------------------------- 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