http://in.compucrete.com/index.php?action=history&feed=atom&title=QueryGen_Case%3A_Security_Work
QueryGen Case: Security Work - Revision history
2026-05-15T16:57:35Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=QueryGen_Case:_Security_Work&diff=542&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T13:00:35Z
<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-541:rev-542 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=QueryGen_Case:_Security_Work&diff=541&oldid=prev
Intra>Chanson: /* Duplicate Elimination */
2019-08-02T12:45:48Z
<p><span dir="auto"><span class="autocomment">Duplicate Elimination</span></span></p>
<p><b>New page</b></p><div>==Security in QueryGen==<br />
<br />
===Duplicate Elimination===<br />
This will eliminate duplicate items (which can be difficult to delete) and creates a good script that can replace security in another database (like when copying from one company to another).<br />
<br />
Select:<br />
<PRE><br />
select SECURITY_CLASS,USER_ID,SECTION_NAME,GROUP_NAME,OPTION_NAME,min(LAST_CHANGE_DATETIME) LAST_CHANGE_DATETIME,min(LAST_CHANGE_USER) LAST_CHANGE_USER<br />
from cctsectl<br />
group by SECTION_NAME,GROUP_NAME,OPTION_NAME,SECURITY_CLASS,USER_ID<br />
</PRE><br />
<br />
Header:<br />
<PRE><br />
DELETE FROM CCTSECTL;<br />
</PRE><br />
<br />
Model:<br />
<PRE><br />
INSERT INTO cctsectl<br />
( SECURITY_CLASS, USER_ID, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER ) VALUES <br />
( '{SECURITY_CLASS}', '{USER_ID}', '{SECTION_NAME}', '{GROUP_NAME}', '{OPTION_NAME}', '{LAST_CHANGE_DATETIME}', '{LAST_CHANGE_USER}' );<br />
</PRE><br />
<br />
===Add ZZ Items to a Role===<br />
Example of creating a role items from a new "ZZ" security items:<br />
<br />
Select:<br />
<PRE><br />
SELECT * FROM cctsectl<br />
where last_change_datetime between '7/26/19' and '7/29/19'<br />
</PRE><br />
<br />
<PRE><br />
DELETE FROM CCTSECTL WHERE LAST_CHANGE_DATETIME='8/1/19';<br />
</PRE><br />
<br />
<PRE><br />
INSERT INTO cctsectl<br />
( SECURITY_CLASS, USER_ID, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER ) VALUES <br />
( NULL, '~DISPATCH', '{SECTION_NAME}', '{GROUP_NAME}', '{OPTION_NAME}', '8/1/19', 'HIT' );<br />
</PRE></div>
Intra>Chanson