question

Steve-7386 avatar image
0 Votes"
Steve-7386 asked Joyzhao-MSFT commented

SCCM - Access to some reports not working

Hi,

I'm trying to give access to two users to 1 specific report OS>Computers with a specific operating system
i tried multiple ways by AD security group to manually adding the user to the report properties - security..... still not working
the results are either the user gets all access to all reports or nothing access denied.

please help.

thanks,

sql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you mean viewing the reports on the report server? If so, you need to add permissions to the user in the web portal.

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Steve-7386 commented

Hi @Steve-7386 ,
What permissions have you set for users?
Scope defines the boundaries within which roles are used. Item-level roles provide varying levels of access to report server items and operations that affect those items. Item-level roles are defined on the root node (Home) and all items throughout the report server folder hierarchy. System-level roles authorize access at the site level.

Role assignments are inherited within the folder hierarchy and are automatically inherited by contained:

  • Reports

  • Shared data sources

  • Resources

  • Subfolders

Role-based security in Reporting Services is organized into the following levels:

  • Item-level role assignments control access to items in the report server folder hierarchy such as:
    reports
    folders
    report models
    shared data sources
    other resources

  • Item-level role assignments are defined when create a role assignment on a specific item, or on the Home folder.

  • System role assignments authorize operations that are scoped to the server as a whole. For example, the ability to manage jobs is a system level operation. A system role assignment isn't the equivalent of a system administrator. It doesn't confer advanced permissions that grant full control of a report server.

A system role assignment doesn't authorize access to items in the folder hierarchy. System and item security are mutually exclusive. Sometimes, you might need to create both a system-level and item-level role assignment to provide sufficient access for a user or group.

For more information,please refer to: Role Definitions. Role Assignments.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Joyzhao,
Thanks for the information. But can you provide a sample of how I can give a user access to 1 report ? like a step by step way showing how can i give access to a user to 1 or 2 reports.

Thanks,

0 Votes 0 ·

Hi @Steve-7386 ,
Please refer to: Grant user access to a report server or Granting access in SSRS to reports. Before adding users to a native mode report server, you must be a member of the local Administrators group on the report server computer.
If you have any questions,please feel free to let me know.
Best Regards,
Joy


0 Votes 0 ·

I tried all that, nothing is working. All i want to do is give a user access to a specific report/s and whatever i do it either works and gets all access or if i start modifying he cant access anything, its kind of frustrating to be honest lol

Thanks,

0 Votes 0 ·
Steve-7386 avatar image
1 Vote"
Steve-7386 answered Joyzhao-MSFT commented

Ok, so I added them in the Administrative Users section // created a role under Security Roles // added them to that role// I notice that the permissions take time to push, so wait for that.
but thanks for the help.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If you have any questions later, you can always feel free to let me know.

0 Votes 0 ·