The package extracts data from a remote server and inserts it in the PROD database on the local SQL Server 2008 instance. You deploy the package to the MSDB database on the production server.

You need to ensure that users can view, execute, and delete their own packages.

What should you do?

1)Assign the users to the db_ssisoperator role.

2)Assign the users to the db_ssisltduser role.

3)Assign the users to a custom database role in the PROD database.

4)Assign the users to the db_ssisadmin role.

  • : 273
  • : 18
    Previous Next

    Assign the users to the db_ssisltduser role.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence

    Recommended Learning for you

    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material