Now that we've created a new user we can assign the user database and table specific privileges to get
started.
Click on the edit privileges button next to our new user
we can skip it past and global privileges section because we've already specified not to give the user
any global privileges
scroll down to the heading database specific privileges.
Here we can assign a database to our new user from the drop down menu next to the label add privileges
on the following database.
Select my website in the first section on this page.
We can assign database specific privileges any privileges you assigned here will be applicable to all
tables inside the specified database in this case.
The my Web site database if you want the user to be able to make all structural administrative and data
related changes to any table inside the database click the check all button
otherwise you can specify which privileges you want to grant.
We won't be granting any database specific privileges here because we want to restrict this user to
tables specific privileges to do that.
Scroll down to the heading table specific privileges from the drop down menu next to the label add privileges
on the following table select the user's table
from here we can specify exactly which privileges to grant for each column in this table.
So we call that we have five columns I.D. First Name Last Name Email in date for the purpose of this
example let's allow the user to select Insert and update the first name last name in email columns inside
this table to select multiple column headings hold the control or command key if you're on a Mac
the privileges displayed here on the right side are table level privileges.
So anything you check off will be applicable to the entire table.
For that reason we won't be checking any boxes here once complete click on the go button to see the
changes
and that's it.
Now our changes have been saved so we can go back to the users age.