SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40 Record Type: 1 User Codes 08/28/2009 File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"U" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1) User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3) User Name . . . . . . . . . . . . . . . UserName. . . . . . . . . . . String (5,30) Supervisor Rights? (Y/N). . . . . . . . SupervisorRights. . . . . . . Yes/No (35,1) Applies To User Type 'U' Only . . . . . . . . . . . . . . . . . . . Memo External User . . . . . . . . . . . . . ExternalUser. . . . . . . . . Yes/No (36,1) Blank is interpreted as "Y" . . . . . . . . . . . . . . . . . . . . Memo Named User. . . . . . . . . . . . . . . NamedUser . . . . . . . . . . Yes/No (37,1) Display 'My Business' on Launcher . . . DisplayMyBusinessOnLauncher . Yes/No (38,1) Blank is interpreted as 'Y' . . . . . . . . . . . . . . . . . . . . Memo Company Code Prompt . . . . . . . . . . CompanyCodePrompt . . . . . . Yes/No (39,1) Blank is interpreted as N . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (40,3) User Type . . . . . . . . . . . . . . . UserType. . . . . . . . . . . String (43,1) U=User. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo G=Group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Group Code. . . . . . . . . . . . . . . GroupCode . . . . . . . . . . String (44,3) Password. . . . . . . . . . . . . . . . Password. . . . . . . . . . . String (47,9) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (56,4) Reserved for Future Password Exp. . . . . . . . . . . . . . . . . . Memo Lockout Date. . . . . . . . . . . . . . LockoutDate . . . . . . . . . Date (60,6) Lockout Time. . . . . . . . . . . . . . LockoutTime . . . . . . . . . Zero-Filled (66,6) User Flags. . . . . . . . . . . . . . . UserFlags . . . . . . . . . . String (72,1) ________ Total Bytes 74
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40 Record Type: 2 User/Company/Application Security 08/28/2009 File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"C" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1) User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3) Application Code. . . . . . . . . . . . ApplicationCode . . . . . . . String *(8,3) ________ Total Bytes 12
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40 Record Type: 3 Menu Security 08/28/2009 File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"M" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1) Application Code. . . . . . . . . . . . ApplicationCode . . . . . . . String *(2,3) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3) (A Blank Company Code Indicates . . . . . . . . . . . . . . . . . . Memo All Companies). . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Menu Bar Number . . . . . . . . . . . . MenuBarNumber . . . . . . . . Zero-Filled *(8,2) Option Number . . . . . . . . . . . . . OptionNumber. . . . . . . . . Zero-Filled *(10,2) (An Option Number Of "00" Refers. . . . . . . . . . . . . . . . . . Memo To Entire Menu Bar) . . . . . . . . . . . . . . . . . . . . . . . . Memo User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(12,3) ________ Total Bytes 16
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40 Record Type: 4 ODBC/SQL Password Record 08/28/2009 File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"O" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . Uppercase *(1,1) "RPT" . . . . . . . . . . . . . . . . . RPT . . . . . . . . . . . . . Uppercase *(2,3) SQL Password. . . . . . . . . . . . . . SQLPassword . . . . . . . . . String (5,16) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (21,37) ________ Total Bytes 59
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40 Record Type: 5 External User Record 08/28/2009 File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type ("c") . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1) User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3) Validation String . . . . . . . . . . . ValidationString. . . . . . . String (5,50) ________ Total Bytes 56
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40 Record Type: 6 Named User Record 08/28/2009 File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type ("d") . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1) User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3) Validation String . . . . . . . . . . . ValidationString. . . . . . . String (5,50) ________ Total Bytes 56