• svoj@may.pils.ru's avatar
    BUG#7391 - Cross-database multi-table UPDATE uses active database · 67db270c
    svoj@may.pils.ru authored
               privileges
    
    This problem is 4.1 specific. It doesn't affect 4.0 and was fixed
    in 5.x before.
    
    Having any mysql user who is allowed to issue multi table update
    statement and any column/table grants, allows this user to update
    any table on a server (mysql grant tables are not exception).
    
    check_grant() accepts number of tables (in table list) to be checked
    in 5-th param. While checking grants for multi table update, number
    of tables must be 1. It must never be 0 (actually we have
    DBUG_ASSERT(number > 0) in 5.x in grant_check() function).
    67db270c
grant.test 15.6 KB