Difference between revisions of "JCM Table: dbo.ADM ReportAccessPermissions"

From Sherlock Software
(Created page with "===TABLE NAME: dbo.ADM_ReportAccessPermissions=== {| class="wikitable" |- ! Col ID !! Name !! Data Type !! Description |- | 1 || reportID || smallint || |- | 2 || userGroupID...")
 
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
===TABLE NAME: dbo.ADM_ReportAccessPermissions===
===TABLE NAME: dbo.ADM_ReportAccessPermissions===
This table is used to record which user group can access which report.
{| class="wikitable"
{| class="wikitable"
|-
|-
! Col ID !! Name !! Data Type !! Description
! Col ID !! Name !! Data Type !! Description
|-
|-
| 1 || reportID || smallint ||  
| 1 || reportID || smallint || Report id
|-
|-
| 2 || userGroupID || smallint ||  
| 2 || userGroupID || smallint || ID of the user group that can access the report
|}
|}
</br>
</br>

Latest revision as of 23:26, 30 December 2021

TABLE NAME: dbo.ADM_ReportAccessPermissions

This table is used to record which user group can access which report.

Col ID Name Data Type Description
1 reportID smallint Report id
2 userGroupID smallint ID of the user group that can access the report



Back to JCM Database tables