PrepAway - Latest Free Exam Questions & Answers

what should you do to make sure that the the stored procedures in the MSDB database are executed by using the

You are the administrator of your company network. There’s a SQL Server 2008 instance which hosts a new database application in your company. Now you want to develop the security requirements for the application. Each application user has his own login to the SQL Server 2008 server. The application database executes stored procedures in the MSDB database in which the stored procedures schedule SQLAgent jobs. You must make sure that the the stored procedures in the MSDB database are executed by using the security context of the application user. So what should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should add each user to the public role in the MSDB database.

B.
You should add each user to the dbdtsltduser database role in the MSDB database.

C.
You should configure the MSDB database to use the TRUSTWORTHY option, and then add each user to the MSDB database.

D.
You should configure the new database to use the TRUSTWORTHY option, and then add each user to the MSDB database.


Leave a Reply