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