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