title: `CREATE ALGORITHM=UNDEFINED DEFINER` requires super permissions
body: <p>I am trying to import one of my old databases to my new database.</p>
  
  <p>To do this I created a user with the same privileges as before:</p>
  
  <p>Almost every command seems to work except the following:</p>
  
  <pre><code>CREATE ALGORITHM=UNDEFINED DEFINER=`foo`@`localhost` SQL SECURITY DEFINER VIEW `wp_affiliate_wp_campaigns` AS select `wp_affiliate_wp_visits`.`affiliate_id` AS `affiliate_id`,`wp_affiliate_wp_visits`.`campaign` AS `campaign`,count(`wp_affiliate_wp_visits`.`url`) AS `visits`,count(distinct `wp_affiliate_wp_visits`.`url`) AS `unique_visits`,sum(if((`wp_affiliate_wp_visits`.`referral_id` &lt;&gt; 0),1,0)) AS `referrals`,round(((sum(if((`wp_affiliate_wp_visits`.`referral_id` &lt;&gt; 0),1,0)) / count(`wp_affiliate_wp_visits`.`url`)) * 100),2) AS `conversion_rate` from `wp_affiliate_wp_visits` group by `wp_affiliate_wp_visits`.`affiliate_id`,`wp_affiliate_wp_visits`.`campaign`;
  </code></pre>
  
  <p>Which gave me the following error:</p>
  
  <pre><code>Error Code: 1227. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  </code></pre>
  
  <p>This is odd as this table was created with the a user with the same permissions as my old database (i.e. all permissions for table <code>foo</code>).</p>
  
  <p>So my question is:</p>
  
  <ul>
  <li>What exactly does this command do?</li>
  <li>Why do I suddenly need super permission to execute it when my old database never did?</li>
  </ul>