Database Reference
In-Depth Information
Figure 12.4
Grant permission to user Smith.
6. After the user Smith is created, highlight and run the following SQL statement to
grant the SELECT permission to Smith as shown in Figure 12.4:
GRANT SELECT
ON BUILDING
TO Smith
7. To test the login, log of from the current user. hen, log in with the user
Smith
and
password PWF@rCa$$&/-7 to the database
Class_Registration
. In the
New Query
pane, run the following SQL Statement:
SELECT * FROM BUILDING
8. With the permission granted, Smith should be able to run the SELECT statement as
shown in Figure 12.5.
9. However, Smith should not be able to run the UPDATE SQL statement as shown in
Figure 12.6.
As illustrated above, user management can be done through SQL statements. More
management-related tasks will be discussed in the following sections.
