Task $1(5$ Marks$)$

$1.$ Create three users with the following usernames:

a$.\_1($for instance, kyt$012\_1)$

b$.\_2$

c$.\_3$

d$.$ Set all passwords to be the same as the username.

$2.$ Use GRANT statement$($s$)$ to grant $\_1$ the privileges to alter

relational tables, to drop relational tables, and to read and write relational tables in the

database created in the previous step. The privilege must be granted such that $\_1$ is able to grant the privileges to the other users.

$3.$ Use GRANT statement$($s$)$ to grant $\_2$ the privileges to read

data from the Book and Author tables. The privilege must be granted such that the $\_2$ is NOT able to grant the privileges to the other users.

$4.$ Use ALTER USER statement to set the resource limits of $\_3$:

total number of queries issued per hour must be set to $100,$ and total number of updates

issued per hour must be set to $10.$

University of Wollongong

School of Computing and Information Technology

CSIT$115$ Data Management and Security

Page $2$ of $3$

$5.$ Use ALTER USER statement$($s$)$ to expire the password of $\_2.$

$6.$ Use SELECT statement$($s$)$ to retrieve and display the privileges granted to all the users.

$7.$ Save the SQL commands and the result from step $(6)$ into a text file. The file name must

be $\_\_$task$1.$txt$.$ Example: T$1\_1234567\_$task$1.$txt$.$