As the database owner, you grant Franz permissions to create views and create stored procedures in the Finance database. France creates a stored procedure that does an update on the dbo.prices table. He creates a view that selects price information for a report. He grants Suzanne SELECT permissions on the view and EXECUTE permissions on the stored procedure. What must be done so that Suzann e can obtain the results by using the view and stored procedure?
A. A.You must grant Suzanne SELECT permissions on the view and the stored procedure.
B. B.Franz must grant Suzanne SELECT permissions on the Prices table.
C. You must grant Suzanne SELECT and UPDATE permissions on the Prices table.
D. D.Franz must grant Suzanne EXECUTE permissions on the stored procedure and SELECT permissions on the Prices table.
Answer:C
As the database owner, you grant Franz permissions to create views and create stored procedures in the Finance database. France creates a stored procedure that does an update on the dbo.prices table. He creates a view that selects price information for a report. He grants Suzanne SELECT permissions on the view and EXECUTE permissions on the stored procedure. What must be done so that Suzann e can obtain the results by using the view and stored procedure?
A. A.You must grant Suzanne SELECT permissions on the view and the stored procedure. B. B.Franz must grant Suzanne SELECT permissions on the Prices table. C. You must grant Suzanne SELECT and UPDATE permissions on the Prices table. D. D.Franz must grant Suzanne EXECUTE permissions on the stored procedure and SELECT permissions on the Prices table.