Eksporter (0) Skriv ut
Vis alt
Dette innholdet er ikke tilgjengelig på ditt språk, men her er den engelske versjonen.

Update Permissions (Azure SQL Reporting)

Updated: May 9, 2014

SQL Reporting will discontinue service on October 31, 2014. See this FAQ for details. For reporting on Microsoft Azure, visit Virtual Machines on WindowsAzure.com.

You can set permissions on a folder, data source, or report to allow or deny access to content and operations. Permissions are bundled into roles, such as Browser, Content Manager, Publisher, and so on. Granting permissions occurs when you assign a role to one or more users.

By default, a role is assigned to a user account when you create the account. The default role is Browser, which conveys view permissions throughout the folder hierarchy. Because folders are created directly on the SQL Reporting report server, the permissions set on the root node are automatically inherited by folders, reports, and other items further down in the folder hierarchy. You can increase or restrict permissions on individual items within that hierarchy.

Increasing or restricting permissions is done at the item level. To restrict permissions, for example to hide a report from a Content Manager on the system, you must break permission inheritance on the item, clearing the Content Manager role from that user, for that item.

To ensure manageability, keep user accounts and permissions as simple as possible. There is no central management of users and permissions. You cannot look up individual user accounts to see which items he or she can access. If permissions become too granular, you might lose track of who has permissions on specific items in the folder hierarchy.

To grant permissions

  1. Open a Web browser, and launch the Azure Platform Management Portal by specifying the appropriate Microsoft Azure credentials. Open the SQL Reporting server.

  2. Click Items at the top of the page.

  3. Select the folder, report, or data source and then click Manage Permissions at the bottom of the page.

  4. Click Assign Item-specific permissions.

  5. Find users by scrolling down the existing list of users. Select a user.

  6. In Permissions, select a role. Roles are cumulative.

    Content Manager is all inclusive, providing the highest permissions, including ability to delete content and create or modify role assignments.

    Browser and Publisher grant permissions to view and add content, respectively, but without the ability to delete content or modify role assignments.

  7. Click the checkbox to save your changes.

To restrict permissions on a data source or a report

  1. Click Items at the top of the page.

  2. Select the folder, report, or data source and then click Manage Permissions at the bottom of the page.

  3. Click Assign Item-specific permissions.

  4. Find users by scrolling down the existing list of users.

  5. Click the user for whom you want to restrict permissions.

  6. Click the X next to the right of the role assignments. The role assignment is immediately deleted for the current item. You are not prompted to confirm the action.

  7. Click the checkmark to save your changes.

See Also


Legg til
© 2014 Microsoft