• unknown's avatar
    Bug#19857: When a user with CREATE ROUTINE priv creates a routine it results in NULL p/w · cfc10401
    unknown authored
      
    sp_grant_privileges(), the function that GRANTs EXECUTE + ALTER privs on a SP,
    did so creating a user-entry with not password; mysql_routine_grant() would then
    write that "change" to the user-table.
    
    
    mysql-test/r/sp-security.result:
      prove that creating a stored procedure will not destroy the creator's password
    mysql-test/t/sp-security.test:
      prove that creating a stored procedure will not destroy the creator's password
    sql/sql_acl.cc:
      get password from ACLs, convert to correct format, and use it when
      forcing GRANTS for SPs
    cfc10401
sp-security.test 17.4 KB