Control access to report builder

Jawaher Khemakhem 1 Reputation point
2021-03-05T14:10:54.807+00:00

I have a report in report builder.

Now I want to control access to this report automatically
,
Is there a way to check if a user can access or not to a report using a refrence table in sql server?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,360 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 22,216 Reputation points
    2021-03-08T06:21:16.757+00:00

    Hi @Jawaher Khemakhem ,

    Do you mean that you want to use t-sql to consult the user's permission of the report in SSMS?

    If yes, you may refer the below code to see if it could meet your needs.

    select C.UserName, D.RoleName, D.Description, E.Path, E.Name   
    from dbo.PolicyUserRole A  
       inner join dbo.Policies B on A.PolicyID = B.PolicyID  
       inner join dbo.Users C on A.UserID = C.UserID  
       inner join dbo.Roles D on A.RoleID = D.RoleID  
       inner join dbo.Catalog E on A.PolicyID = E.PolicyID  
    order by C.UserName     
    

    If I misunderstand your needs, please incorrect me.

    Regards´╝î

    Zoe


    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.
    Hot issues October