SELECT USER_NAME, USER_TYPE FROM amsecusers SELECT USER_NAME, COOP_ID, PASSWORD, TERMINAL_NAME, COOPBRANCH_ID, USER_ID, APVLEVEL_ID, COOP_CONTROL, USER_LEVEL, USER_TYPE, APVCASH_FLAG, POINT_OFCASH, FREEZ_FLAG, INITIAL_NAME, USER_C, SHOWSALARY_FLAG, DESCRIPTION, FULL_NAME, TABLEFIN_CODE FROM amsecusers