InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Extra Roles Available In Msdb? |
|
Answer» db_ssisadmin: Equals to sysadmin db_ssisoperator: Import/Delete/Change Role of own packages db_ssisltduser: Only can view and execute the packages dc_admin: Can administrate and USE the data collector dc_operator: Can administrate and use the data collector dc_proxy : Can administrate and use the data collector PolicyAdministratorRole: can perform all CONFIGURATION and maintenance activities on Policy-Based Management POLICIES and conditions. ServerGroupAdministratorRole : Can administrate the registered server group ServerGroupReaderRole: Can view and the registered server group dbm_monitor: Created in the msdb database when the first database is registered in Database Mirroring MONITOR db_ssisadmin: Equals to sysadmin db_ssisoperator: Import/Delete/Change Role of own packages db_ssisltduser: Only can view and execute the packages dc_admin: Can administrate and use the data collector dc_operator: Can administrate and use the data collector dc_proxy : Can administrate and use the data collector PolicyAdministratorRole: can perform all configuration and maintenance activities on Policy-Based Management policies and conditions. ServerGroupAdministratorRole : Can administrate the registered server group ServerGroupReaderRole: Can view and the registered server group dbm_monitor: Created in the msdb database when the first database is registered in Database Mirroring Monitor |
|