Control access to report builder

Question

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?

Answer 1

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