Sheila Smith

1
Excellence in Training, Doctrine, and Combat
Development


Sheila Smith Armor ASAT Program Manager
2
Preventing Global Lock Outs

• Two Types of global lock outs
• 1. Every local user in your database is
  inactive.
• 2. Your database takes on another schools
  identity.
• What causes these global lock outs?
• Directly importing information from another
  school into our working database the sharing of
  information.
• The Armor School prevents global lock out by
• Never importing directly into the working
  database.
• Removing all users except the ASAT System
  Administrator and the Reviewer from the transfer
  database prior to importing the information into
  our working database.

3
School Identity Theft

• The Armor School utilized Infomaker to recover
  our identity change the school codes back to
  Armor.

4
School Identity Theft
continued
Sample of the Armor Schools database site id
information from Infomaker
5
School Identity Theft
continued

• Or you can use the isql.exe method. However, my
  recommendation for a lock out that is associated
  with school identity theft is to contact
• ATSC ASAT Manager, Elaine Tarr
• (757) 878- 4762, Ext 7044DSN 826- 4762, Ext
  7044FAX [phone]elaine.tarr_at_us.army.mil

6
Armor School Import Steps

• Take the transfer database (from another school
  or contractor) that was created using the steps
  Elaine presented earlier, and connect to it to
  review the data.
• Since ASAT defaults to your working database, to
  connect to your transfer database on the power
  panel select File, attach to other databases. In
  my example below, I have created a TOMA
  profile.

7
Armor School Import Steps
continued

• Logon to the transfer database as the
  Administrator (use id admin and password asat).
• When prompted to change the password, change the
  password.
• Select System Admin on the ASAT Power Panel.
  Select ASAT User Administration.
• Filter by clicking All. This will bring up the
  ASAT User Maintenance Screen with every user

8
Armor School Import Steps
continued

• At the User Maintenance Screen, remove all users
  except the ASAT System Administrator and Reviewer
  by
• -- From the file menu, select data then
  select/deselect record (the record will turn
  blue when selected). Then select data delete
  record. You can delete several records at a time
  by holding the shift key and clicking on records.

9
Armor School Import Steps
continued
10
Benefits of utilizing a transfer database

• It prevents your active users from becoming
  inactive (locked out)
• It prevents your working database from taking on
  another schools identity/school codes. NOTE If
  your database takes on another schools identity
  every user including your administrators and any
  administrative back doors will be disabled.
• If the information you are importing is corrupt
  you will not corrupt your active database.

11
Benefits of utilizing a transfer database
continued

• You are able to choose specific items you want to
  import into your working database.
• You are able to remove outdated facilities,
  products, TADSS, and other items that appear
  under the support tab.

12
Questions

• Questions or concerns contact
• Sheila Smith
• DSN 464-6352 or Com 502-624-6352
• Email sheila.m.smith_at_us.army.mil