reporting-servicesreportserver

Purpose of dbo.Policies table in SSRS


What is the purpose of the [dbo].][Policies] table in SSRS ReportServerDB database?

I see two columns, PolicyID and PolicyFlag and I don't get any clue about purpose of this table. Is it possible to add anew row into that table and what represents those data, i.e. rows?


Solution

  • Each row of Policies table declares via PolicyFlag column if that policy is defined for system roles.

    A policy can be related only with created user defined objects, UserType = 1 in User table. System defined objects like NT AUTHORITY\SYSTEM and Local Server Administrator aren't mapped with policies.

    If you run this query:

    SELECT b.username, 
           c.policyflag, 
           d.rolename, 
           b.usertype, 
           c.policyid 
    FROM   policyuserrole a 
           INNER JOIN users b 
                   ON a.userid = b.userid 
           INNER JOIN policies c 
                   ON a.policyid = c.policyid 
           INNER JOIN roles d 
                   ON a.roleid = d.roleid 
    

    enter image description here

    By default you will have two rows in Policies table.

    REFERENCE

    Let me know if this helps.