Assume that each of the three users, User$1,$ User$2$ and User$3,$ has the privileges to create database tables and views and to issue SQL statements on the database tables and views that he$/$she has created. Assume that User$1$ has created the two following tables:

BOOKS $($book$\_$id$,$ book$\_$name, publication$\_$year, author$\_$name$)$

AUTHORS $($author$\_$name, education$\_$level, address$)$

User$1$ then has also issued the following SQL statement:

GRANT SELECT ON BOOKS TO User$2$

WITH GRANT OPTION

Using the scenario described above, User$2$ has the privilege to allow User$3$ to update data stored in the table BOOKS: