Dispatch: Creating Default Security Settings

The Following Setup script will install basic security.

• Security level 35 and above can run end of day, edit prices.
• Security level 65 and above can make changes to plant table including add and delete.

INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '35', 'CCMENU', 'OPTION', 'DIPRTXF', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '65', 'ARFMPLT', 'FIELD', 'PLANT_TYPE', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '65', 'ARFMPLT', 'FIELD', 'TICKET_SOURCE', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '65', 'ARFMPLT', 'FIELD', 'LAST_INVOICE_NO', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '65', 'ARFMPLT', 'FIELD', 'INVOICE_SOURCE', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '65', 'ARFMPLT', 'FIELD', 'SYS_LOC', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '65', 'ARFMPLT', 'ITEM', 'DELETE', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '65', 'ARFMPLT', 'ITEM', 'ADD', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '35', 'CCMENU', 'OPTION', 'ARFMJPR', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '35', 'CCMENU', 'OPTION', 'ARFMGPR', '3/1/2007', 'HIT'  );
INSERT INTO cctsectl (
   SECURITY_CLASS, SECTION_NAME, GROUP_NAME, OPTION_NAME, LAST_CHANGE_DATETIME, LAST_CHANGE_USER )  
    VALUES ( '35', 'CCMENU', 'OPTION', 'ARFMCPR', '3/1/2007', 'HIT'  );