You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
Now you are responsible for the security in SQL Server 2008 Reporting Services (SSRS).
After a new user is assigned to a role, you should give the permissions to the user, making the user publish reports and manage content only in a private folder.
So what action should you perform? (Exhibit)
A.
You should assign the user to the Content Manager and the Report Builder roles
B.
You should assign the user to the Publisher role.
C.
You should assign the user to the My Reports role
D.
You should assign the user to the Content Manager and the Browser roles.
Explanation:
http://msdn.microsoft.com/en-us/library/ms156338.aspxMy Reports Role
SQL Server 2008 R2 Other Versions
The My Reports role is a predefined role that includes a set of tasks that are useful for users of the My Reports feature. This role definition includes tasks that grant administrative permissions to users over the My Reports folder that they own.Although you can choose another role to use with the My Reports feature, it is recommended that you choose one that is used exclusively for My Reports security. For more information, see Securing My Reports.