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.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!