70-463 · Question #182
You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. Package developers in your company must have permission to perform the…
The correct answer is B. Add developer logins to the db_ssisoperator role in the msdb database. D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments. B: db_ssisoperator Enumerate all packages. View all packages. Execute all packages. Export all packages. Execute all packages in SQL Server Agent. D: Need read permissions on the Environments in order to be able to view them. Not A: db_ssisltduser Enumerate own packages…
Question
You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. Package developers in your company must have permission to perform the following tasks only on their own projects:
- View projects and packages
- View Environments
- Validate packages
- Execute packages
You need to grant rights to the developers without assigning unnecessary privileges. What should you do? (Each correct answer presents part of a solution. Choose all that apply.)
Options
- AAdd developer logins to the db_ssisltduser role in the msdb database.
- BAdd developer logins to the db_ssisoperator role in the msdb database.
- CGrant Execute permission in the projects for the developer logins.
- DGrant Read permission in the SSIS catalog folder, the projects, and the Environments.
- EAdd developer logins to the ssis_admin role in the SSISDB database.
- FGrant Modify permission in the projects for the developer logins.
How the community answered
(20 responses)- A15% (3)
- B70% (14)
- E5% (1)
- F10% (2)
Explanation
B: db_ssisoperator Enumerate all packages. View all packages. Execute all packages. Export all packages. Execute all packages in SQL Server Agent. D: Need read permissions on the Environments in order to be able to view them. Not A: db_ssisltduser Enumerate own packages. Enumerate all packages. View own packages. Execute own packages. Export own packages. Import packages. Delete own packages. Change own package roles. Not E: db_ssisadmin Too many permissions (such as delete all packages).
Topics
Community Discussion
No community discussion yet for this question.