Exercise: User Management and Access Control
Practice and test your understanding of user management and access control.
We'll cover the following...
We'll cover the following...
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:
Field | Type |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Where ProductID is the primary key and CategoryID is the foreign key from the Categories table. The table contains information about products.
Grant ...