.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

Popular posts from this blog

c++ - Linux and clipboard -

Visual Studio 2005: How to speed up builds when a VSMDI is open? -

booting ubuntu from usb using virtualbox -