title: Give User Create and Update View Permissions only
body: <p>Does anyone know if there is a way in MySQL to allow the user to create / alter views without giving the user the ability to drop table within the database?</p>
  
  <p>I have the need to give user ability to create / alter views.</p>
  
  <p>Don't know if you can deny drop permissions to specific table and would that still effect the ability of the user to create / update views.</p>
  
  <p>The reason I am asking this is because I am not the DBA of the system, but need to be able to create views. </p>
  
  <p>Again, if someone can tell me it is or isn't possible, or even shed some light on how it can be done.</p>