You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance contains a database named CK_DB that contains a table named CK_Tbl.
CK_DB also contains a stored procedure named CK_Prod that uses a
sp_executesql Transact-SQL statement to get data from CK_Tbl.
A new Domain.com security policy does not allow users to access tables directly in any database.
If it does happened that a user runs ProcedureTest"Msg 229, Level 14, State 5, Line 1,
it will give the following error.
The SELECT permission was denied on the object ‘ CK_Tbl’, database ‘ CK_DB ‘, schema ‘dbo’.
You need to ensure that the users can run CK_Prod and still comply with the Domain.com security policy.
What should you do?
A.
You should consider modifying CK_Prod and increase the WITH EXECUTE AS OWNER option to its header.
B.
You should consider modifying CK_Prod and the WITH EXECUTE AS OWNER option to its header.
C.
You should consider running, GRANT SELECT ON dbo.Master’TO Clerk.
D.
You should consider running, GRANT SELECT ON dbo.CK_Tbl’TO Clerk.