MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
All members of the sysadmin built-in server role have permission to administer SQL Server Agent jobs. If you need to grant permission to administer jobs to logins that are not members of the sysadmin role, three fixed roles are available for this purpose in the msdb database. Choose three.
A
SQLAgentUserRole
B
SQLAgentQuestRole
C
SQLAgentReaderRole
D
SQLAgentOperatorRole
E
SQLAgentAdminRole
Explanation: 

Detailed explanation-1: -In addition, there are only two ways that someone can have permission to execute a SQL Agent job. You must either own the job, or be a member of the role SQLAgentOperatorRole (MSDB).

Detailed explanation-2: -Using SQL Server Management Studio Right-click a stored procedure and select Properties. In the Stored Procedure Properties-stored procedure name dialog box, under select a page, select Permissions. Use this page to add users or roles to the stored procedure and specify the permissions those users or roles have.

Detailed explanation-3: -SQLAgentOperatorRole members have additional permissions on local jobs and schedules. They can execute, stop, or start all local jobs, and they can delete the job history for any local job on the server. They can also enable or disable all local jobs and schedules on the server.

There is 1 question to complete.
Previous
Next