9. Security

Activity 9.01: Grant UPDATE permission on a table in MySQL

Solution:

1. Update the permission for TEMP_ACCOUNT_2 using the following code:

   USE packt_online_shop; 
   GRANT UPDATE ON TABLE packt_online_shop.products TO 'TEMP_ACCOUNT_2';

2. Write the following code to view the

   SHOW GRANTS FOR 'TEMP_ACCOUNT_2';

3. Execute the query, you should get the result:

Figure 9.6: All permissions provided to TEMP_ACCOUNT_2