http://in.compucrete.com/index.php?action=history&feed=atom&title=Security_Report_Queries
Security Report Queries - Revision history
2026-05-15T15:29:02Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Security_Report_Queries&diff=618&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T13:00:37Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-617:rev-618 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Security_Report_Queries&diff=617&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:02:20Z
<p>1 revision imported</p>
<p><b>New page</b></p><div><br />
<PRE><br />
select USER_GROUP_ID "User",OPTION_NAME "Option Name",OPTION_VALUE "Option Value",LAST_CHANGE_DATETIME "Last Changed",Last_change_user "Last Change User" from cctoptn <br />
where option_name in <br />
('GLSYSTEM','CMSYSTEM','ARSYSTEM','APSYSTEM','PRSYSTEM','DATASCOPE','INVENTORYACTIVE','TISYSTEM')<br />
order by user_group_id,option_name<br />
</PRE><br />
<br />
<PRE><br />
select security_class "Sec Class",<br />
user_id "User Override",<br />
Section_Name "Sec Section",group_name "Sec Group",Option_name "Sec Group" from cctsectl<br />
order by security_class,section_name<br />
</PRE></div>
Intra>User