Hi,
I need set lock table privilage for user, but now I must grant upload
priv. for it. But I needn't upload priv. for user. Upload is possible
via RULEs without GRANTed (upload) privilage for user.
My suggestion is add to GRANT command LOCK privilage.
.... privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE | LOCK.... ^^^^
Zakkr