.net - How to import / export user account in Reporting Services? -
There is a table [ReportServer]. [DBO]. [User] But what is the relation with other tables? And how can I make these values?
The values in this table are based on permissions that have the permissions set up in the report hierarchy The most common way to manage it is through Report Manager under Property -> Security.
dbo.Users can be included in dbo.PolicyUserRole. Table deabo Polyacusarroll then dibo. Roll, DBO. Policies, and debut.
Here is a query that provides all reports / models / folders and all their users and related permissions:
SELECT c.Path, u.UserName, r .RoleName, r.Description FROM dbo.Catalog c INNER JOIN dbo.PolicyUserRole at c.PolicyID = pur.PolicyID INNER JOIN Dbo. Overus U pur.UserID = u.UserID Inner dino.Roles r on r. ROLID = R. ROLID
Comments
Post a Comment