[Webdev] mysql grant permissions

[Philip Reynolds]

Dave Burke's [dave at compsoc.com] 62 lines of dribble included:
:>So the question now, is how user "dave" was able to execute that select
:>query when all he _should_ have is insert/update access? Do granting
:>insert or update access automatically grant select access as well ?
:>
:>I just checked and mysql.tables_priv contains......
:>| %    | test    | dave  | weirdness           | root at localhost |
:>20000626191015 | Insert,Update
:>
:>
:>Does anyone know how to stop a user from having select access but still
:>have insert & update access ?

To be honest, I reckon update would need to have select access to actually be
able to know what the hell it's updating. I don't think you can have an update
without a select. 
Phil.