title: "ANY Command denied for user" with View-over-View DDL via JDBC
body: <p>I'm having a pretty weird issue here. We're using Pentaho Kettle to manage the schema of our database (which in turn uses the MySQL JDBC mysql-connector-java-5.1.17.jar). When trying to create a view which includes another view (interfaces in this case), we get:</p>
  
  <pre><code>2012/06/26 11:46:55 - SQL2 - ERROR : Couldn't execute SQL: CREATE OR REPLACE VIEW `test_delete2` as select  * from interfaces
  2012/06/26 11:46:55 - SQL2 - ERROR : ANY command denied to user 'ncim'@'xxx.xxx.xxx..xx' for table '/var/mysql/mysql2018/tmp/#sql_4e67_0'
  </code></pre>
  
  <p>However, using the same statement and user, but via the mysql command line client, works as expected. Also, creating views with JDBC over ordinary tables works as well.</p>
  
  <p>This is with MariaDB 5.2.10 on Solaris 10 on the server side, but we're having the same issue with Oracle MySQL too.</p>
  
  <p>Any good ideas what could cause this? </p>
  
  <p>PS: I'm aware that creating views over views isn't the best idea ever, but assume for the moment that it can't be avoided in this case.</p>