question

JawaherKhemakhem-3381 avatar image
0 Votes"
JawaherKhemakhem-3381 asked ZoeHui-MSFT commented

Control access to report builder

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
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.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @JawaherKhemakhem-3381,

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

· 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.

may I know how's the issue going on now?

0 Votes 0 ·