You administer a SQL Server 2008 instance that will host a new database application. You
plan to design the security requirements for the application. Each application user has a
unique login to the SQL Server 2008 server. The application database contains stored
procedures to execute stored procedures in the MSDB database. The stored procedures in
the MSDB database schedule SQLAgent jobs. You need to ensure that the stored
procedures in the MSDB database are executed by using the security context of the
application user. What should you do?
A.
Configure the MSDB database to use the TRUSTWORTHY option, and then add each
user to the MSDB database.
B.
Configure the new database to use the TRUSTWORTHY option, and then add each user
to the MSDB database.
C.
Add each user to the public role in the MSDB database.
D.
Add each user to the db_dtsltduser database role in the MSDB database.