$7$:$30$

To$-$do

Assignment details

CSCI$-2215-01$

Description

You must write a SQL statement$($s$)$ to execute access control requests for each of the following:

Give Tom the privilege to read the entire Department table, insert rows into the Department table, and pass on these privileges to other users.

Revoke Tom's privilege to insert rows into the Department table and revoke this privilege from anyone who received that privilege from Tom.

Give Jessica the privilege to insert or update rows in the Works$\_$On table, but do not allow Jessica to pass these privileges on to other users.

Give Mark the privilege to view the names and addresses of all employees who work for the Research department.

Give Allison the privilege to read the entire Dependent table and to use the primary key in that table as a foreign in other tables she creates in the database.

Assume Tom, Jessica, Mark and Allison are valid userids.