InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
You Are Delegating Permissions On Your Sql Server To Other Administrators. You Have Local, Single Server Jobs On One Server That You Would Like To Allow Another Administer To Start, Stop, And View The History For, But Not Delete History. This Administrator Will Own The Jobs. Which Role Should You Assign? |
|
Answer» SQLAgentUserRole: SQL Server PROVIDES 3 fixed roles for the agent service that limit privileges for ADMINISTRATORS. The SQLAgentUserRole is designed for local jobs (not multiserver) that allow the member to work with their OWNED jobs (EDIT, start, stop, view history) without deleting the history of any job. SQLAgentUserRole: SQL Server provides 3 fixed roles for the agent service that limit privileges for administrators. The SQLAgentUserRole is designed for local jobs (not multiserver) that allow the member to work with their owned jobs (edit, start, stop, view history) without deleting the history of any job. |
|