The User Table

Each record in this table represents a different user

Each user table record holds the following data

Field                        Type                Comments

LastAccess                Date/Time        Last access by this user

LocalDBase                Text(255)        User database name

OK2Post                Yes/No                Indicates is user allowed to post

OK2001                        Yes/No                Indicates user has access to Job Control

OK2002                        Yes/No                user has access to Front End        

OK2Setup                Yes/No                user has access to Setup

SecurityLevel                Integer                Security level this user has

UsePassword                Yes/No                Indicates if this user requires a password

UserID                        Text(8)                User ID for this user

UserName                Text(50)        Long Name for this user

UserPermissions        Text(255)        All user permissions for this user

JCSuper                Text(255)        List of Job Control supervisors restricted to this user