Exercise: User Management and Access Control

Now it’s time to get some hands-on practice!

Question 1

For our OnlineStore, create a user named inventory_clerk who can only connect from IP addresses in the 10.10.20.x subnet. Assign the password Inv3ntoryCl3rk!.

If you’re stuck, click the “Show Solution” button.

Question 2

Given the following structure of the Products table:

Where ProductID is the primary key and CategoryID is the foreign key from the Categories table. The table contains information about products.

Grant ...