/* Chapter 14 - Try It Out sections */
  
  /* Try It Out: Adding Users to the DVDRentals Database */
  
  GRANT SELECT, UPDATE (EmpFN, EmpMN, EmpLN)
  ON DVDRentals.Employees
  TO 'myuser1'@'localhost' IDENTIFIED BY 'mypw1'
  WITH MAX_CONNECTIONS_PER_HOUR 25;
  
  SELECT host, user, select_priv, update_priv FROM user WHERE user='myuser1';
  SELECT host, db, user, table_name, table_priv, column_priv 
     FROM tables_priv WHERE user='myuser1';
  SELECT host, db, user, table_name, column_name, column_priv 
     FROM columns_priv WHERE user='myuser1';