The database manager wants to give Rubio and Doe the ability to modify the Project...

CIW 1D0-541 Question Answer

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?

GRANT UPDATE ON Project TO Rubio, Doe;

GRANT SELECT ON Project TO Temp;

GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;

GRANT UPDATE ON Project TO Temp;

GRANT SELECT ON Project

WHERE Manager = 'Rubio';

GRANT SELECT ON Project

WHERE Manager = 'Doe';

GRANT UPDATE ON Project

WHERE Manager = 'Rubio';

GRANT UPDATE ON Project

WHERE Manager = 'Doe';