/* 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';