Control access to report builder

Jawaher Khemakhem 1 Reputation point

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,860 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,996 Reputation points

    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.



    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