• anozdrin@mysql.com's avatar
    Fix for BUG#16777: Can not create trigger nor view w/o definer · 302239f3
    anozdrin@mysql.com authored
    if --skip-grant-tables specified.
    
    The problem is that there is a check that prevents creating a definer
    with empty host name.
    
    In --skip-grant-tables mode this check prevents the user from creating a
    trigger/view without explicitly specifying its definer. This happens, because
    in --skip-grant-tables mode CURRENT_USER is ''@''. According to Sanja this
    check was implemented intentionally.
    
    However, according to the MySQL manual it is possible to specify empty host
    name (as well as empty user name). Moreover, the behaviour for stored routines
    is different in this aspect -- we allow them to be created with implicit
    definer.
    
    Based on this, we believe it is OK to change the behaviour for views to be
    similar with the behaviour for stored routines.
    302239f3
sql_view.cc 46.7 KB