How to Create an Account in AMES (Any environment)

Owned by matthew.staynor
Last updated: Oct 04, 2021
1 min read

  1. Connect to the AMES database that you would like the account to be created in

  2. Navigate to the USERADMIN table

  3. Enter in data similar to the above screenshot.

    1. USERID and NAME to match the user’s login information and name

    2. PWORD is NOT ENCRYPTED and has a maximum of 6 characters. Set it to whatever the user’s requested 6-char password is

    3. STARTDATE as today’s date

    4. USERLEVEL_ID set to 1 if it is for an administrator/developer account

      1. If you are unsure of what level to set USERLEVEL_ID to, please refer to page 4 of this document: http://mytc/rdims/15012752/R

  4. Commit your changes. The user should now be able to login to AMES