The database manager wants to give Rubio and Doe the ability to modify the Project Relation
shown in the exhibit. A temporary employee named Temp needs to access the data in the
database to generate reports. Which group of SQL statements will perform this task?
A.
GRANT UPDATE ON Project TO Rubio, Doe;
GRANT SELECT ON Project TO Temp;
B.
GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
GRANT UPDATE ON Project TO Temp;
C.
GRANT SELECT ON Project
WHERE Manager = ‘Rubio’;
GRANT SELECT ON Project
WHERE Manager = ‘Doe’;
D.
GRANT UPDATE ON Project
WHERE Manager = ‘Rubio’;
GRANT UPDATE ON Project
WHERE Manager = ‘Doe’;
GRANT SELECT ON Project TO Temp;