Jump to content
Wubi

navy.mil; dhs.gov; ua.edu; database leaked by digital-coruption

Recommended Posts

Posted (edited)

Credits:

.########..####..######...####.########....###....##........######...#######..########..########..##.....##.########..########.####..#######..##....##
.##.....##..##..##....##...##.....##......##.##...##.......##....##.##.....##.##.....##.##.....##.##.....##.##.....##....##.....##..##.....##.###...##
.##.....##..##..##.........##.....##.....##...##..##.......##.......##.....##.##.....##.##.....##.##.....##.##.....##....##.....##..##.....##.####..##
.##.....##..##..##...####..##.....##....##.....##.##.......##.......##.....##.########..########..##.....##.########.....##.....##..##.....##.##.##.##
.##.....##..##..##....##...##.....##....#########.##.......##.......##.....##.##...##...##...##...##.....##.##...........##.....##..##.....##.##..####
.##.....##..##..##....##...##.....##....##.....##.##.......##....##.##.....##.##....##..##....##..##.....##.##...........##.....##..##.....##.##...###
.########..####..######...####....##....##.....##.########..######...#######..##.....##.##.....##..#######..##...........##....####..#######..##....##
[ / s3lf-d3struct / Bw0mp / s0lar / 3piC/ Vapor /]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= #[x] RM'D YOUR SERVERS, UMAD?
############################################
say("#FreeTriCk #FreeMLT #FreePhantom");
say("Knowledge is power!");
say("NAVY.MIL, care to share some of your staff information?");
############################################
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
OUR SITE: Digital-corruption.org
OUR TWITTERS:
@digitalcorrupt
@s3lf_d3struct
@bw0mp
@_s0lar_
And we want to give a special thanks to vapor @vap0rizer

Navy.mil:

####################################################################################
#==================================================================================#
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
#==================================================================================#
# _____ _ _ __ _____ _ _ #
# |_ _| | | | | / _| / __ \ | | | | #
# | | __ _| |__ | | ___ ___ | |_ | / \/ ___ _ __ | |_ ___ _ __ | |_ ___ #
# | |/ _` | '_ \| |/ _ \ / _ \| _| | | / _ \| '_ \| __/ _ \ '_ \| __/ __| #
# | | (_| | |_) | | __/ | (_) | | | \__/\ (_) | | | | || __/ | | | |_\__ \ #
# \_/\__,_|_.__/|_|\___| \___/|_| \____/\___/|_| |_|\__\___|_| |_|\__|___/ #
# #
#==================================================================================#
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
#==================================================================================#
# 1.0 - NAVY.MIL - 1.0 #
# 2.0 - DHS.GOV - 2.0 #
# 3.0 - UA.EDU - 3.0 #
# #
#==================================================================================#
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
#==================================================================================#
####################################################################################


_ _ ___ ____ ____ __ ___ _
| \ | | / \ \ / /\ \ / / \/ |_ _| |
| \| | / _ \ \ / / \ V /| |\/| || || | GETTING OWNED? YES SIR!
| |\ |/ ___ \ V / | |_| | | || || |___
|_| \_/_/ \_\_/ |_(_)_| |_|___|_____|

~$ Target: Navy.mil
~$ Vulnerable subdomain: https://www.smartwebmove.navsup.navy.mil/
~$ Exploitable method: Blind Oracle SQLi


# # ( )
___#_#___|__
_ |____________| _
_=====| | | | | |==== _
=====| |.---------------------------. | |====
<--------------------' . . . . . . . . '--------------/
\ I H4XX3D MY OWN BOAT? <333 /
\__FIRE THE DATABASE <333___________________________________/
wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww


====DATABASES====

Available databases [3]:
[*] HHG_MGR
[*] SYS
[*] SYSTEM

====TABLES====

Database: HHG_MGR
[104 tables]
+--------------------------------+
| ACCOUNT |
| ACCOUNT_ARCH |
| ACCOUNT_TEMP |
| APPLICATION_STATUS |
| APPLICATION_STATUS_ARCH |
| APPLICATION_STATUS_TEMP |
| APPLICATION_STEPS |
| CONTACT_INFO |
| CONTACT_INFO_ARCH |
| DD1299 |
| DD1299_ARCH |
| DEPARTURE_INFO |
| DOM_PPSO_CONTACT_INSTR |
| ELIGIBILITY |
| ELIGIBILITY_ARCH |
| FIREARMS |
| FIREARMS_ARCH |
| HHG_QRESPONSES |
| HHG_QRESPONSES_ARCH |
| HOLIDAY_DATES |
| INSURANCE_ELECTIONS |
| INSURANCE_ELECTIONS_ARCH |
| MEMBER_CONTACT |
| MEMBER_CONTACT_ARCH |
| MEMBER_ORDERS |
| MEMBER_ORDERS_ARCH |
| MOBILE_HOMES |
| MOBILE_HOMES_ARCH |
| MOTORCYCLES |
| MOTORCYCLES_ARCH |
| MOVE_INFO |
| MOVE_INFO_ARCH |
| NEW_DUTY_STATION_INFO |
| NEW_DUTY_STATION_INFO_ARCH |
| NTS_EXTENSION_SHIPMENT |
| NTS_EXTENSION_SHIPMENT_ARCH |
| NTS_RELEASE_SHIPMENT |
| NTS_RELEASE_SHIPMENT_ARCH |
| NTS_SHIPMENT |
| NTS_SHIPMENT_ARCH |
| ORDERS_MASTER |
| ORDERS_MASTER_ARCH |
| PERSONNEL |
| POINT_OF_CONTACT |
| POINT_OF_CONTACT_ARCH |
| POV |
| POV_ARCH |
| PPCIG_CONSUMABLES |
| PPCIG_CONSUMABLES_SPECIFICS |
| PPCIG_COUNTRY_CODE |
| PPCIG_COUNTRY_INFO |
| PPCIG_COUNTRY_INFO_WEIGHTS |
| PPCIG_COUNTRY_WEIGHTS |
| PPCIG_CUSTOMS_CLEARANCE |
| PPCIG_CUSTOMS_CLEARANCE_SPEC |
| PPCIG_ELECTRICAL_EQUIPMENT |
| PPCIG_ELECTRIC_EQUIPMENT_SPEC |
| PPCIG_FIREARMS |
| PPCIG_FIREARMS_SPECIFICS |
| PPCIG_FURNITURE |
| PPCIG_FURNITURE_SITE_SPECIFICS |
| PPCIG_FURNITURE_SPECIFICS |
| PPCIG_OTHER |
| PPCIG_OTHER_SITE_SPECIFICS |
| PPCIG_OTHER_SPECIFICS |
| PPCIG_PETS |
| PPCIG_PETS_SPECIFICS |
| PPCIG_PORN |
| PPCIG_PORN_SPECIFICS |
| PPCIG_POV |
| PPCIG_POV_SPECIFICS |
| PPCIG_SEPARATION |
| PPCIG_SEPARATION_SITE_SPEC |
| PPCIG_SERVICE_CODE |
| PPCIG_SHIP_INSTRUCTIONS |
| PPCIG_SHIP_INSTRUCTIONS_SPEC |
| PPCIG_STUFFED_WILDLIFE |
| PPCIG_STUFF_WILDLIFE_SITE_SPEC |
| PPCIG_SUBCHAPTER |
| PPCIG_TRANSMIT_EQUIPMENT |
| PPCIG_TRANSMIT_EQUIP_SITE_SPEC |
| PPM_INFO |
| PPM_INFO_ARCH |
| PROCESSING_CENTERS |
| RELEASE_ITEMS |
| RELEASE_ITEMS_ARCH |
| SHIPMENT |
| SHIPMENT_ARCH |
| SHIPMENT_SUPPLEMENT |
| SHIPMENT_SUPPLEMENT_ARCH |
| SHIP_ADDL_ADDRESSES |
| SHIP_ADDL_ADDRESSES_ARCH |
| SHIP_ADDRESSES |
| SHIP_ADDRESSES_ARCH |
| SHIP_WEIGHTS |
| SHIP_WEIGHTS_ARCH |
| SURVEY |
| SWM_QUEUE |
| SWM_QUEUE_ARCH |
| TOAD_PLAN_TABLE |
| UNUSUAL_OVERSIZE_ITEMS |
| UNUSUAL_OVERSIZE_ITEMS_ARCH |
| WEIGHT_ENTITLEMENT |
| ZIP_TO_GBLOC |
+--------------------------------+

Database: SYS
[24 tables]
+-------------------------------+
| HS_PARALLEL_METADATA |
| KUNOEXP_TAB |
| KU_DATAPUMP_MASTER_10_1 |
| KU_DATAPUMP_MASTER_11_1 |
| KU_DATAPUMP_MASTER_11_1_0_7 |
| KU_DATAPUMP_MASTER_11_2 |
| KU_LIST_FILTER_TEMP |
| KU_LIST_FILTER_TEMP_2 |
| ODCI_PMO_ROWIDS |
| ODCI_SECOBJ |
| ODCI_WARNINGS |
| PLAN_TABLE |
| WRI_ADV_ASA_RECO_DATA |
| WRR_REPLAY_CALL_FILTER |
| AUDIT_ACTIONS |
| DUAL |
| HS_BULKLOAD_VIEW_OBJ |
| HS_PARTITION_COL_NAME |
| HS_PARTITION_COL_TYPE |
| IMPDP_STATS |
| PSTUBTBL |
| STMT_AUDIT_OPTION_MAP |
| SYSTEM_PRIVILEGE_MAP |
| TABLE_PRIVILEGE_MAP |
+-------------------------------+

Database: SYSTEM
[4 tables]
+-----------+
| OL |
| OLHINTS |
| OLNODES |
| HELP |
+-----------+


====COLUMNS====

Database: HHG_MGR
Table: ACCOUNT
[18 columns]
+------------------------+----------+
| Column | Type |
+------------------------+----------+
| ACTIVE_FLAG | VARCHAR2 |
| ADMIN_FLAG | VARCHAR2 |
| ASSIGNED_COUNSELOR_ID | VARCHAR2 |
| CONFIRMATION_STRING | VARCHAR2 |
| COUNSELOR_NOTES | VARCHAR2 |
| DISTINGUISHED_NAME | VARCHAR2 |
| DUPLICATE | CHAR |
| LAST_ACTIVE_DATE | DATE |
| ORDERS_SERIAL_KEY | NUMBER |
| PASSWORD_CREATED_DATE | DATE |
| PASSWORD_HINT | VARCHAR2 |
| PROC_PROCESSING_CENTER | VARCHAR2 |
| SESSION_ID | VARCHAR2 |
| SSN | VARCHAR2 |
| SUBMIT_DATE | DATE |
| TOPS_SUBMIT_DATE | DATE |
| USER_PASSWORD | VARCHAR2 |
| USERNAME | VARCHAR2 |
+------------------------+----------+
Database: HHG_MGR
Table: DD1299
[11 columns]
+-------------------------------+----------+
| Column | Type |
+-------------------------------+----------+
| DATE_DD1299_PRINTED | DATE |
| DD1299_BLOCK13_REMARKS | VARCHAR2 |
| DD1299_DATE_PREPARED | DATE |
| DD1299_MAILED_IN | VARCHAR2 |
| DD1299_PREPARING_INSTALLATION | VARCHAR2 |
| DD1299_REASON_NO_SIGNATURE | VARCHAR2 |
| DD1299MAIL_OUT | VARCHAR2 |
| NAME_OF_CERTIFYING_OFFICER | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
| TITLE_OF_CERTIFYING_OFFICER | VARCHAR2 |
+-------------------------------+----------+
Database: HHG_MGR
Table: DEPARTURE_INFO
[15 columns]
+-----------------+--------+
| Column | Type |
+-----------------+--------+
| ABBR_POV | CLOB |
| BOAT | CLOB |
| CONSUMABLES | CLOB |
| COUNTRY_INFO_ID | NUMBER |
| CUSTOMS | CLOB |
| FIREARM | CLOB |
| FURNITURE | CLOB |
| HOUSING | CLOB |
| JETSKI | CLOB |
| MISCELLANEOUS | CLOB |
| MOTORCYCLE | CLOB |
| PET | CLOB |
| PLANT | CLOB |
| PORN | CLOB |
| POV | CLOB |
+-----------------+--------+
Database: HHG_MGR
Table: FIREARMS
[7 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| FARM_CALIBER | VARCHAR2 |
| FARM_MAKE | VARCHAR2 |
| FARM_MODEL | VARCHAR2 |
| FARM_SERIAL_NBR | VARCHAR2 |
| FARM_VALUE | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
+-------------------+----------+
Database: HHG_MGR
Table: INSURANCE_ELECTIONS
[3 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
| TYPE_OF_INSURANCE | VARCHAR2 |
+-------------------+----------+
Database: HHG_MGR
Table: MEMBER_CONTACT
[36 columns]
+--------------------------------+----------+
| Column | Type |
+--------------------------------+----------+
| DESTINATION_SPONSOR_NAME | VARCHAR2 |
| DESTINATION_SPONSOR_PHONE | VARCHAR2 |
| DESTINATION_SPONSOR_PHONE_EXT | VARCHAR2 |
| HHG_CONTACT_NAME | VARCHAR2 |
| HHG_INTRANSIT_CONTACT_NAME | VARCHAR2 |
| HHG_STORAGE_COMPANY_NAME | VARCHAR2 |
| HHG_STORAGE_LOT_ID | VARCHAR2 |
| HHG_STORAGE_PHONE | VARCHAR2 |
| HHG_STORAGE_PHONE_EXT | VARCHAR2 |
| MBR_DEST_CONT_PHONE_NUMBER_EXT | VARCHAR2 |
| MBR_DEST_CONTACT_CITY | VARCHAR2 |
| MBR_DEST_CONTACT_COUNTRY | VARCHAR2 |
| MBR_DEST_CONTACT_PHONE_NUMBER | VARCHAR2 |
| MBR_DEST_CONTACT_STATE | VARCHAR2 |
| MBR_DEST_CONTACT_STREET | VARCHAR2 |
| MBR_DEST_CONTACT_ZIP_APO_FPO | VARCHAR2 |
| MBR_DEST_DUTY_PHONE_NUMBER | VARCHAR2 |
| MBR_DEST_DUTY_PHONE_NUMBER_EXT | VARCHAR2 |
| MBR_INTRANS_CONTACT_PHONE_EXT | VARCHAR2 |
| MBR_INTRANSIT_CARE_OF_NAME | VARCHAR2 |
| MBR_INTRANSIT_CONTACT_CITY | VARCHAR2 |
| MBR_INTRANSIT_CONTACT_COUNTRY | VARCHAR2 |
| MBR_INTRANSIT_CONTACT_PHONE | VARCHAR2 |
| MBR_INTRANSIT_CONTACT_STATE | VARCHAR2 |
| MBR_INTRANSIT_CONTACT_STREET | VARCHAR2 |
| MBR_INTRANSIT_ZIP_APO_FPO | VARCHAR2 |
| MBR_ORG_DUTY_PHONE_NUMBER_EXT | VARCHAR2 |
| MBR_ORG_HOME_PHONE_NUMBER_EXT | VARCHAR2 |
| MBR_ORIGIN_CONTACT_CITY | VARCHAR2 |
| MBR_ORIGIN_CONTACT_COUNTRY | VARCHAR2 |
| MBR_ORIGIN_CONTACT_STATE | VARCHAR2 |
| MBR_ORIGIN_CONTACT_STREET | VARCHAR2 |
| MBR_ORIGIN_CONTACT_ZIP_APO_FPO | VARCHAR2 |
| MBR_ORIGIN_DUTY_PHONE_NUMBER | VARCHAR2 |
| MBR_ORIGIN_HOME_PHONE_NUMBER | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
+--------------------------------+----------+
Database: HHG_MGR
Table: MEMBER_ORDERS
[57 columns]
+--------------------------------+----------+
| Column | Type |
+--------------------------------+----------+
| ACCOMPANIED_TOUR_OVERSEAS | VARCHAR2 |
| ACCOUNTING_CLASSIFICATION | VARCHAR2 |
| ADMIN_RESTRICTED_WEIGHT | NUMBER |
| ADMIN_WEIGHT_ADJUSTMENT | NUMBER |
| APPROXIMATE_REPORTING_DATE | DATE |
| CHARGE_WT_TO_SPON_MBR_ORDERS | VARCHAR2 |
| COMBINED_MOVE_SPOUSE_IN_SERV | VARCHAR2 |
| COUNSELOR_INITIALS | VARCHAR2 |
| CURRENT_DUTY_STATION | VARCHAR2 |
| DEPENDENT_TRAVEL_AUTHORIZED | VARCHAR2 |
| DEPENDENT_TRAVEL_CONCURRENT | VARCHAR2 |
| DEPENDENT_TRAVEL_DELAYED | VARCHAR2 |
| DEPENDENT_UB_TABULAR_WEIGHT | NUMBER |
| DEPLOYMENT_MOVE | VARCHAR2 |
| FULL_JTR_TABULAR_WEIGHT_PCS | NUMBER |
| FULL_JTR_TABULAR_WEIGHT_TDY | NUMBER |
| IB_FILE_FOLDER_LABEL_PRINTED | VARCHAR2 |
| JOINT_MOVE_SPOUSE_IN_SERVICE | VARCHAR2 |
| MBR_CHOOSES_UB_SURFACE_ALTERN | VARCHAR2 |
| MEMBER_BRANCH_OF_SERVICE | VARCHAR2 |
| MEMBER_FISCAL_YEAR_OF_DETACH | NUMBER |
| MEMBER_IN_PAY_STATUS_AT_DEST | VARCHAR2 |
| MEMBER_MOVING_TO_GOVT_HOUSING | VARCHAR2 |
| MEMBER_NAVY_RANK_RATE_CODE | VARCHAR2 |
| MEMBER_OVER_2_YEARS_SERVICE | VARCHAR2 |
| MEMBER_PAY_GRADE | VARCHAR2 |
| MEMBER_RANK | VARCHAR2 |
| MEMBER_UB_TABULAR_WEIGHT | NUMBER |
| MOVEMENT_DESIGNATOR_CODE | VARCHAR2 |
| NAVY_NMF_CODE | VARCHAR2 |
| NEW_DUTY_STATION | VARCHAR2 |
| NTS_FILE_FOLDER_LABEL_PRINTED | VARCHAR2 |
| NUMBER_OF_DEPENDENTS_UNDER_12 | NUMBER |
| NUMBER_OF_DEPN_12_AND_OVER | NUMBER |
| OB_FILE_FOLDER_LABEL_PRINTED | VARCHAR2 |
| OLD_ISSUING_HQTRS | VARCHAR2 |
| OLD_ORDERS_DATE | DATE |
| ORDERS_AMENDED | VARCHAR2 |
| ORDERS_DATE | DATE |
| ORDERS_ISSUING_HEADQUARTERS | VARCHAR2 |
| ORDERS_PARAGRAPH_NUMBER | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| PCS_WITH_TDY_INDICATOR | VARCHAR2 |
| RETIREMENT_SEPARATION_DATE | DATE |
| SPONSORED_DEPENDENT_FIRST_NAME | VARCHAR2 |
| SPONSORED_DEPENDENT_LAST_NAME | VARCHAR2 |
| SPONSORED_DEPENDENT_MOVE | VARCHAR2 |
| SPONSORED_DEPN_MID_NAM_OR_INIT | VARCHAR2 |
| SPONSORING_MBR_ORDERS_NUMBER | VARCHAR2 |
| SPONSORING_MEMBER_ORDERS_DATE | DATE |
| TIMESTAMP | DATE |
| TOUR_OVERSEAS | VARCHAR2 |
| TRANSPORTATION_ACCOUNT_CODE | VARCHAR2 |
| TYPE_OF_ORDERS | VARCHAR2 |
| UB_WEIGHT_ADJUSTMENT | NUMBER |
| UNIT_GAINING_MEMBER | VARCHAR2 |
| UNIT_LOSING_MEMBER | VARCHAR2 |
+--------------------------------+----------+
Database: HHG_MGR
Table: MOBILE_HOMES
[17 columns]
+--------------------+----------+
| Column | Type |
+--------------------+----------+
| MOBH_ADDRESS | VARCHAR2 |
| MOBH_CITY | VARCHAR2 |
| MOBH_COUNTRY | VARCHAR2 |
| MOBH_EXPANDABLE | VARCHAR2 |
| MOBH_HEIGHT | VARCHAR2 |
| MOBH_LENGTH | VARCHAR2 |
| MOBH_MAKE | VARCHAR2 |
| MOBH_MODEL | VARCHAR2 |
| MOBH_STATE | VARCHAR2 |
| MOBH_TRANSPORTABLE | VARCHAR2 |
| MOBH_TYPE | VARCHAR2 |
| MOBH_WIDTH | VARCHAR2 |
| MOBH_YEAR | NUMBER |
| MOBH_ZIPCODE | VARCHAR2 |
| MOBH_ZIPCODE_EXT | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
+--------------------+----------+
Database: HHG_MGR
Table: MOVE_INFO
[9 columns]
+--------------------+----------+
| Column | Type |
+--------------------+----------+
| DUPLICATE | CHAR |
| IN_GOVT_STORAGE | VARCHAR2 |
| MEMB_SSN | VARCHAR2 |
| MOVE_TYPE | VARCHAR2 |
| OCONUS_MOVE | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| RECENT_MOVE | VARCHAR2 |
| WEIGHT_ENTITLEMENT | NUMBER |
| YEARS_IN_SERVICE | VARCHAR2 |
+--------------------+----------+
Database: HHG_MGR
Table: NEW_DUTY_STATION_INFO
[16 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| ARRIVAL_DATE | DATE |
| CITY | VARCHAR2 |
| COUNTRY | VARCHAR2 |
| DSN | VARCHAR2 |
| DUPLICATE | CHAR |
| HOMEPORT | VARCHAR2 |
| MEMB_SSN | VARCHAR2 |
| NEW_DUTY_STATION | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| RECEIPT_DATE | DATE |
| STATE | VARCHAR2 |
| STREET_ADDRESS | VARCHAR2 |
| WORK_PHONE | VARCHAR2 |
| WORK_PHONE_EXT | VARCHAR2 |
| ZIPCODE | VARCHAR2 |
| ZIPCODE_EXT | VARCHAR2 |
+-------------------+----------+
Database: HHG_MGR
Table: NTS_EXTENSION_SHIPMENT
[9 columns]
+----------------------+----------+
| Column | Type |
+----------------------+----------+
| DATE_OF_STORAGE | DATE |
| DATE_TO_EXTENSION | DATE |
| LOT_NUMBER | VARCHAR2 |
| NTS_LOCATION_NUMBER | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| RESPONSIBLE_PPO | VARCHAR2 |
| SERVICE_ORDER_NUMBER | VARCHAR2 |
| SHIPMENT_NUMBER | NUMBER |
| WEIGHT | VARCHAR2 |
+----------------------+----------+
Database: HHG_MGR
Table: NTS_RELEASE_SHIPMENT
[9 columns]
+----------------------+----------+
| Column | Type |
+----------------------+----------+
| DATE_OF_STORAGE | DATE |
| DATE_TO_RELEASE | DATE |
| LOT_NUMBER | VARCHAR2 |
| NTS_LOCATION_NUMBER | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| RESPONSIBLE_PPO | VARCHAR2 |
| SERVICE_ORDER_NUMBER | VARCHAR2 |
| SHIPMENT_NUMBER | NUMBER |
| WEIGHT | VARCHAR2 |
+----------------------+----------+
Database: HHG_MGR
Table: NTS_SHIPMENT
[65 columns]
+--------------------------------+----------+
| Column | Type |
+--------------------------------+----------+
| CURRENT_NTS_PRO_GEAR_WT | NUMBER |
| CURRENT_NTS_STORED_WT | NUMBER |
| DATE_CONVERTED_TO_MBR_EXPENSE | DATE |
| DATE_NEW_APPROP_EFFECTIVE | DATE |
| DATE_NTS_EXPIR_LETTER1_PRINTED | DATE |
| DATE_NTS_EXPIR_LETTER2_PRINTED | DATE |
| DATE_NTS_EXTENSION_AUTHORIZED | DATE |
| DATE_QTRLY_STG_INVOICE_PRINTED | DATE |
| ESTIMATED_NTS_REMOVAL_DATE | DATE |
| ESTIMATED_PERIOD_OF_NTS | NUMBER |
| FINANCE_OFFICE_CODE | VARCHAR2 |
| HHG_ALT_CONTACT_NAME | VARCHAR2 |
| HHG_ALT_CONTACT_PHONE_COM | VARCHAR2 |
| HHG_ALT_CONTACT_PHONE_DSN | VARCHAR2 |
| HHG_ALT_CONTACT_PHONE_EXT | VARCHAR2 |
| HHG_LT_CONTACT_RELATIONSHIP | VARCHAR2 |
| MBR_PERM_ADDR_CARE_OF_NAME | VARCHAR2 |
| MBR_PERMANENT_ADDR_CITY | VARCHAR2 |
| MBR_PERMANENT_ADDR_COUNTRY | VARCHAR2 |
| MBR_PERMANENT_ADDR_PH_COM | VARCHAR2 |
| MBR_PERMANENT_ADDR_PH_DSN | VARCHAR2 |
| MBR_PERMANENT_ADDR_PHONE_EXT | VARCHAR2 |
| MBR_PERMANENT_ADDR_STATE | VARCHAR2 |
| MBR_PERMANENT_ADDR_STREET | VARCHAR2 |
| MBR_PERMANENT_ADDR_ZIP_APO_FPO | VARCHAR2 |
| MINIMUM_WEIGHT_VALUE | NUMBER |
| NEW_APPROPRIATION_IDENT_CODE | VARCHAR2 |
| NTS_ACTION | VARCHAR2 |
| NTS_APPROPRIATION_IDENT_CODE | VARCHAR2 |
| NTS_BOA_MOD_NUMBER | VARCHAR2 |
| NTS_BOA_MOD_STATUS_CODE | VARCHAR2 |
| NTS_BOA_NUMBER | VARCHAR2 |
| NTS_CONSTR_WT_USED_INDICATOR | VARCHAR2 |
| NTS_CONTRACTOR_CODE | VARCHAR2 |
| NTS_ENTITLEMT_EXPIRATION_DATE | DATE |
| NTS_EXT_AUTH | VARCHAR2 |
| NTS_EXTENSION_AUTHORITY | VARCHAR2 |
| NTS_EXTENSION_REASON | VARCHAR2 |
| NTS_FEDERAL_AGENCY | VARCHAR2 |
| NTS_LOT_NUMBER | VARCHAR2 |
| NTS_MULT_SHIPMT_SEQ_NUM | NUMBER |
| NTS_PENDING_OVERSEAS_SHIPMENT | VARCHAR2 |
| NTS_PRO_GEAR_AUTHORIZED | VARCHAR2 |
| NTS_RESPONSIBLE_GBLOC | VARCHAR2 |
| NTS_SERVICE_ORDER_NUMBER | VARCHAR2 |
| NTS_TYPE | VARCHAR2 |
| NUMBER_OF_MONTHS_NTS_AUTH | NUMBER |
| OLD_BOA_MOD_NUMBER | VARCHAR2 |
| OLD_BOA_NUMBER | VARCHAR2 |
| OLD_CONTRACTOR_CODE | VARCHAR2 |
| OLD_DATE_APPROP_EFFECTIVE | DATE |
| OLD_ENTITLEMT_EXPIR_DATE | DATE |
| OLD_MONTHS_AUTH | NUMBER |
| OLD_NTS_BOA_MOD_STATUS_CODE | VARCHAR2 |
| OLD_NTS_LOT_NUMBER | VARCHAR2 |
| OLD_NTS_SERVICE_ORDER_NUMBER | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| PART_OF_DEPLOYMENT_INDICATOR | VARCHAR2 |
| SHIPMENT_NUMBER | NUMBER |
| SPECIAL_RATE_REQUIRED | VARCHAR2 |
| SPECTRANS_STG_FAC_ID | VARCHAR2 |
| SPECTRANS_TCD_UPDATED | VARCHAR2 |
| STG_PERIOD_BEFORE_NEW_APPROP | NUMBER |
| STORAGE_FACILITY_ID | VARCHAR2 |
| WGT_STORED_AT_MBR_EXPENSE | NUMBER |
+--------------------------------+----------+
Database: HHG_MGR
Table: ORDERS_MASTER
[8 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| MBR_OSK | NUMBER |
| MEMB_FIRST_NAME | VARCHAR2 |
| MEMB_LAST_NAME | VARCHAR2 |
| MEMB_MID_NAME_OR_INIT | VARCHAR2 |
| MEMB_SSN | VARCHAR2 |
| OLD_ORDERS_NUMBER | VARCHAR2 |
| ORDERS_NUMBER | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
+-----------------------+----------+
Database: HHG_MGR
Table: PERSONNEL
[18 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| ALT_DSN | VARCHAR2 |
| ALT_PHONE | VARCHAR2 |
| ALT_PHONE_EXT | VARCHAR2 |
| DSN | VARCHAR2 |
| EFFECTIVE_DATE | DATE |
| EFFECTIVE_DELETE_DATE | DATE |
| EMAIL | VARCHAR2 |
| FAX | VARCHAR2 |
| FIRST_NAME | VARCHAR2 |
| INITIALS | VARCHAR2 |
| LAST_NAME | VARCHAR2 |
| MID_NAME_OR_INIT | VARCHAR2 |
| PROCESSING_CENTER | VARCHAR2 |
| SUPERVISOR_ID | VARCHAR2 |
| TEAM_ID | VARCHAR2 |
| USERNAME | VARCHAR2 |
| WORK_PHONE | VARCHAR2 |
| WORK_PHONE_EXT | VARCHAR2 |
+-----------------------+----------+
Database: HHG_MGR
Table: POINT_OF_CONTACT
[14 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| CITY | VARCHAR2 |
| CONTACT_NAME | VARCHAR2 |
| CONTACT_TYPE | VARCHAR2 |
| COUNTRY | VARCHAR2 |
| DSN | VARCHAR2 |
| DUPLICATE | CHAR |
| MEMB_SSN | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| PHONE | VARCHAR2 |
| PHONE_EXT | VARCHAR2 |
| STATE | VARCHAR2 |
| STREET_ADDRESS | VARCHAR2 |
| ZIPCODE | VARCHAR2 |
| ZIPCODE_EXT | VARCHAR2 |
+-------------------+----------+
Database: HHG_MGR
Table: POV
[9 columns]
+----------------------------+----------+
| Column | Type |
+----------------------------+----------+
| IS_POV_DRIVABLE | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| POV_IDENTIFICATION_NUMBER | VARCHAR2 |
| POV_LICENSE_NUMBER | VARCHAR2 |
| POV_LICENSE_STATE_OF_ISSUE | VARCHAR2 |
| POV_MAKE | VARCHAR2 |
| POV_MODEL | VARCHAR2 |
| POV_YEAR | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
+----------------------------+----------+
Database: HHG_MGR
Table: PPCIG_CUSTOMS_CLEARANCE
[5 columns]
+-------------------+--------+
| Column | Type |
+-------------------+--------+
| CUSTOMS_ID | NUMBER |
| DD1434 | CLOB |
| GENERAL_INS | CLOB |
| INTRATHEATER_SHIP | CLOB |
| PERSONAL_PROPERTY | CLOB |
+-------------------+--------+
Database: HHG_MGR
Table: PPCIG_CUSTOMS_CLEARANCE_SPEC
[3 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CUSTOMS_ID | NUMBER |
| INSTRUCTIONS | CLOB |
| SUBJECT | VARCHAR2 |
+--------------+----------+
Database: HHG_MGR
Table: PPCIG_ELECTRICAL_EQUIPMENT
[5 columns]
+---------------+--------+
| Column | Type |
+---------------+--------+
| ELECTRICAL_ID | NUMBER |
| HOME_PC | CLOB |
| OTHER | CLOB |
| RADIO | CLOB |
| TVS | CLOB |
+---------------+--------+
Database: HHG_MGR
Table: PPCIG_ELECTRIC_EQUIPMENT_SPEC
[4 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ELECTRICAL_ID | NUMBER |
| GBLOC | VARCHAR2 |
| INSTRUCTIONS | CLOB |
| SUBJECT | VARCHAR2 |
+---------------+----------+
Database: HHG_MGR
Table: PPCIG_FIREARMS
[6 columns]
+-------------+--------+
| Column | Type |
+-------------+--------+
| FIREARMS_ID | NUMBER |
| GENERAL_INS | CLOB |
| HANDGUNS | CLOB |
| OTHER | CLOB |
| RIFLES | CLOB |
| TOY_GUNS | CLOB |
+-------------+--------+
Database: HHG_MGR
Table: PPCIG_POV
[15 columns]
+----------------------+--------+
| Column | Type |
+----------------------+--------+
| CONSIGNMENT | CLOB |
| DOCUMENTATION | CLOB |
| GASOLINE_INS | CLOB |
| GENERAL_INS | CLOB |
| INSURANCE_INS | CLOB |
| MODIFIED_VEHICLE | CLOB |
| MOTORCYCLE_INS | CLOB |
| OTHER | CLOB |
| POV_ID | NUMBER |
| REGISTRATION | CLOB |
| REPAIRS | CLOB |
| SAFETY_REQUIREMENTS | CLOB |
| SNOW | CLOB |
| VEHICLE_AVAILABILITY | CLOB |
| WAIVERS | CLOB |
+----------------------+--------+
Database: HHG_MGR
Table: PPCIG_SERVICE_CODE
[2 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| DESCRIPTION | VARCHAR2 |
| SERVICE_CODE | VARCHAR2 |
+--------------+----------+
Database: HHG_MGR
Table: PPCIG_SHIP_INSTRUCTIONS
[6 columns]
+---------------------+--------+
| Column | Type |
+---------------------+--------+
| CONTAINER | CLOB |
| GENERAL_WEIGHT_INFO | CLOB |
| HARD_LIFT | CLOB |
| OTHER | CLOB |
| SHIP_INS_ID | NUMBER |
| UNACCOMPANIED_BAG | CLOB |
+---------------------+--------+
Database: HHG_MGR
Table: PPCIG_SHIP_INSTRUCTIONS_SPEC
[4 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| GBLOC | VARCHAR2 |
| INSTRUCTIONS | CLOB |
| SHIP_INS_ID | NUMBER |
| SUBJECT | VARCHAR2 |
+--------------+----------+
Database: HHG_MGR
Table: PPCIG_TRANSMIT_EQUIPMENT
[6 columns]
+-------------------+--------+
| Column | Type |
+-------------------+--------+
| AMATEUR_HAM_RADIO | CLOB |
| CB | CLOB |
| CORDLESS_PHONE | CLOB |
| DISH | CLOB |
| MARS_EQUIPMENT | CLOB |
| TRANSMIT_ID | NUMBER |
+-------------------+--------+
Database: HHG_MGR
Table: PPCIG_TRANSMIT_EQUIP_SITE_SPEC
[4 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| GBLOC | VARCHAR2 |
| INSTRUCTIONS | CLOB |
| SUBJECT | VARCHAR2 |
| TRANSMIT_ID | NUMBER |
+--------------+----------+
Database: HHG_MGR
Table: PPM_INFO
[11 columns]
+---------------------------+----------+
| Column | Type |
+---------------------------+----------+
| AUTH_DESTINATION_CITY | VARCHAR2 |
| AUTH_DESTINATION_STATE | VARCHAR2 |
| AUTH_ORIGIN_CITY | VARCHAR2 |
| AUTH_ORIGIN_STATE | VARCHAR2 |
| EST_SPOUSE_PRO_GEAR | NUMBER |
| ESTIMATED_PRO_GEAR_WEIGHT | NUMBER |
| ESTIMATED_WEIGHT | NUMBER |
| MOVE_DATE | DATE |
| MOVE_NUMBER | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
+---------------------------+----------+
Database: HHG_MGR
Table: PROCESSING_CENTERS
[8 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| BRANCH_OF_SERVICE | VARCHAR2 |
| COUNTRY_CODE | VARCHAR2 |
| COUNTY_CITY_IND | VARCHAR2 |
| COUNTY_CITY_NAME | VARCHAR2 |
| DESCRIPTION | VARCHAR2 |
| GBLOC | VARCHAR2 |
| GMT_DIFFERENCE | NUMBER |
| STATE | VARCHAR2 |
+-------------------+----------+
Database: HHG_MGR
Table: RELEASE_ITEMS
[4 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| DESCRIPTION | VARCHAR2 |
| ITEM_NBR | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
+-------------------+----------+
Database: HHG_MGR
Table: SHIPMENT
[96 columns]
+--------------------------------+----------+
| Column | Type |
+--------------------------------+----------+
| ADDITIONAL_SERVICE_REQUIRED | VARCHAR2 |
| AGENT_CODE | VARCHAR2 |
| AUTHORIZED_DISTANCE | NUMBER |
| BLUEBARK_MIA_AUTH_SIGNER_NAME | VARCHAR2 |
| BLUEBARK_MIA_AUTH_SIGNER_TITLE | VARCHAR2 |
| CANCEL_OUTBOUND_PART_OF_SHIPMT | VARCHAR2 |
| CARRIER_CODE | VARCHAR2 |
| CODE_OF_SERVICE | VARCHAR2 |
| CODE_OF_SERVICE_FOR_EXCESS_EST | VARCHAR2 |
| CONS_SHIP_NO | VARCHAR2 |
| CONSUMABLES_AUTHORIZED | VARCHAR2 |
| DATE_CANCELLATION_REQUESTED | DATE |
| DATE_COMPLETE_SHIPMENT_ARRIVED | DATE |
| DATE_FAX_PRINTED | DATE |
| DATE_GBL_PRINTED | DATE |
| DATE_SERV_NOTE_PRINTED | DATE |
| DATE_SHIPMENT_COUNSELED | DATE |
| DATE_SHIPMENT_PICKED_UP | DATE |
| DECLARED_VALUATION_AMOUNT | NUMBER |
| DEPLOYMENT_MOVE_NUMBER | VARCHAR2 |
| DESTINATION_DPM_ZONE | VARCHAR2 |
| DESTINATION_GBLOC | VARCHAR2 |
| DESTINATION_RATE_AREA | VARCHAR2 |
| DIRECT_DELIVERY_REQUESTED | VARCHAR2 |
| DPM_SHIPMENT_IND | VARCHAR2 |
| DPM_ZONE | VARCHAR2 |
| DTGBL_ORIGIN_ZONE | VARCHAR2 |
| EXCESS_COST_ESTIMATE | NUMBER |
| EXCESS_COST_PRECOLLECTED | NUMBER |
| EXCESS_COST_TO_PRECOLLECT | NUMBER |
| EXCESS_COSTS_EXIST | VARCHAR2 |
| EXPENSIVE_ITEMS_NO_OF_CARTONS | NUMBER |
| EXPORT_SHIPMENT_INFO_TO_DEST | VARCHAR2 |
| GBL_NUMBER | VARCHAR2 |
| GOCS_ORDERED | VARCHAR2 |
| INSPECTION_REQUESTED_AT_DEST | VARCHAR2 |
| IS_OCONUS | VARCHAR2 |
| LOCAL_MOVE_INDICATOR | VARCHAR2 |
| MBR_CODE_MODE_PREFERENCE | VARCHAR2 |
| MBR_REQUESTED_DELIVERY_DATE | DATE |
| MBR_REQUESTED_PICKUP_DATE | DATE |
| MBR_WILLING_TO_PAY_C_C_PREFER | VARCHAR2 |
| MBR_WILLING_TO_PAY_CODE_PREFER | VARCHAR2 |
| MEMBER_REQUESTED_PACK_DATE | DATE |
| MEMBER_REQUESTED_PACK_DATE_2 | DATE |
| MEMBER_REQUESTED_PACK_DATE_3 | DATE |
| METHOD_OF_SHIPMENT | VARCHAR2 |
| NTS_MULT_SHIPMT_IND | VARCHAR2 |
| NTS_MULT_SHIPMT_SEQ_NUM | NUMBER |
| NTS_MULT_UNPACKING_REQUIRED | VARCHAR2 |
| NUMBER_OF_SPLIT_PORTIONS | NUMBER |
| OLD_SHIPMT_ACCT_CLASS | VARCHAR2 |
| ONE_TIME_ONLY_INDICATOR | VARCHAR2 |
| OPERATING_ALLOW_AMOUNT_ADVANCE | NUMBER |
| OPERATING_ALLOWANCE_AMOUNT | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| ORIGIN_GBLOC | VARCHAR2 |
| ORIGIN_PPPO | VARCHAR2 |
| ORIGIN_RATE_AREA | VARCHAR2 |
| PARCEL_CONSIGNED_TO_DEST_ITO | VARCHAR2 |
| PARCEL_REGISTERED_CERT_NUMBER | VARCHAR2 |
| PARCEL_SERVICE_DATE_SENT | DATE |
| PARCEL_SERVICE_METHOD | VARCHAR2 |
| PARTIAL_DELIVERY_REQUESTED | VARCHAR2 |
| PM_ADVANCE | CHAR |
| PM_TAXES_STATE | CHAR |
| POWER_OF_ATTORNEY_NAME | VARCHAR2 |
| POWER_OF_ATTORNEY_RELATIONSHIP | VARCHAR2 |
| RELEASED_VALUATION_OPTION | VARCHAR2 |
| REMOTE_STAT_NUM_CODE | VARCHAR2 |
| REQUESTED_DISTANCE | NUMBER |
| REQUIRED_DELIVERY_DATE | DATE |
| RESIDENT_PKUP_NUM | NUMBER |
| REWEIGH_NUMBER | VARCHAR2 |
| REWEIGH_REQUESTED_AT_DEST | VARCHAR2 |
| RS_WGT_CHARGE_AGAINST_ENTITLE | VARCHAR2 |
| SHIPMENT_CONTAINS_FIREARMS | VARCHAR2 |
| SHIPMENT_CONTAINS_MOTORCYCLE | VARCHAR2 |
| SHIPMENT_CONTAINS_POV | VARCHAR2 |
| SHIPMENT_NUMBER | NUMBER |
| SHIPMENT_OUT_OF_NTS | VARCHAR2 |
| SHIPMENT_OUT_OF_P_AND_C | VARCHAR2 |
| SHIPMENT_STATUS_CODE | VARCHAR2 |
| SHIPMENT_STATUS_DATE | DATE |
| SHIPMT_ACCOUNT_CLASSIFICATION | VARCHAR2 |
| SHIPMT_CANCELLATION_REQUESTED | VARCHAR2 |
| SPECIAL_SHIPMENT_CIRCUMSTANCE | VARCHAR2 |
| SPLIT_SHIPMENT_INDICATOR | VARCHAR2 |
| TDY_SEGMENT_INDICATOR | VARCHAR2 |
| TIME_FAX_PRINTED | VARCHAR2 |
| TIMESTAMP | DATE |
| TRANSPORTATION_CONTROL_NUMBER | VARCHAR2 |
| TYPE_OF_SHIPMENT | VARCHAR2 |
| VOLUME_MOVE_NUMBER | VARCHAR2 |
| WT_CHARGEABLE_AGAINST_ENTITLE | VARCHAR2 |
| Z_TONNAGE_INDICATOR | VARCHAR2 |
+--------------------------------+----------+
Database: HHG_MGR
Table: SHIPMENT_SUPPLEMENT
[22 columns]
+------------------------+----------+
| Column | Type |
+------------------------+----------+
| GS_RELEASE_TYPE | VARCHAR2 |
| GS_REQUEST_STORAGE_EXT | VARCHAR2 |
| NUM_PACK_DAYS | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| PROF_BOOKS_EQUIP | VARCHAR2 |
| REQ_DELIV_DATE | DATE |
| REQ_PICKUP_DATE_1 | DATE |
| REQ_PICKUP_DATE_2 | DATE |
| REQ_PICKUP_DATE_3 | DATE |
| SHIPMENT_NUMBER | NUMBER |
| SHIPMENT_TYPE | VARCHAR2 |
| SI_BOAT | VARCHAR2 |
| SI_GASOLINE_APPLIANCES | VARCHAR2 |
| SI_JETSKI | VARCHAR2 |
| SI_MOBILEHOME | VARCHAR2 |
| SI_PIANO | VARCHAR2 |
| SI_PLASMA | VARCHAR2 |
| SI_PROPANE_TANK | VARCHAR2 |
| SI_SCUBA | VARCHAR2 |
| SI_UNUSUAL_OVERSIZE | VARCHAR2 |
| SI_UTILITY_TRAILER | VARCHAR2 |
| SI_WASHING_MACHINE | VARCHAR2 |
+------------------------+----------+
Database: HHG_MGR
Table: SHIP_ADDL_ADDRESSES
[36 columns]
+--------------------------------+----------+
| Column | Type |
+--------------------------------+----------+
| ADDL_DEL_DESIG_AGENT_NAME | VARCHAR2 |
| ADDL_DEL_DESIG_AGENT_PH_COM | VARCHAR2 |
| ADDL_DEL_DESIG_AGENT_PH_DSN | VARCHAR2 |
| ADDL_DEL_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
| ADDL_DEL_DESIG_AGENT_RELATN | VARCHAR2 |
| ADDL_DELIVERY_ADDR_CITY | VARCHAR2 |
| ADDL_DELIVERY_ADDR_PHONE | VARCHAR2 |
| ADDL_DELIVERY_ADDR_PHONE_EXT | VARCHAR2 |
| ADDL_DELIVERY_ADDR_STATE | VARCHAR2 |
| ADDL_DELIVERY_ADDR_STREET | VARCHAR2 |
| ADDL_DELIVERY_ADDR_ZIP_APO_FPO | VARCHAR2 |
| ADDL_DELIVERY_COUNTRY | VARCHAR2 |
| ADDL_DELIVERY_COUNTY | VARCHAR2 |
| ADDL_PICKUP_ADDR_CITY | VARCHAR2 |
| ADDL_PICKUP_ADDR_PHONE_NUMBER | VARCHAR2 |
| ADDL_PICKUP_ADDR_STATE | VARCHAR2 |
| ADDL_PICKUP_ADDR_STREET | VARCHAR2 |
| ADDL_PICKUP_ADDR_ZIP_APO_FPO | VARCHAR2 |
| ADDL_PICKUP_COUNTRY | VARCHAR2 |
| ADDL_PICKUP_COUNTY | VARCHAR2 |
| ADDL_PICKUP_DESIG_AGENT_NAME | VARCHAR2 |
| ADDL_PICKUP_DESIG_AGENT_PH_COM | VARCHAR2 |
| ADDL_PICKUP_DESIG_AGENT_PH_DSN | VARCHAR2 |
| ADDL_PICKUP_DESIG_AGENT_RELATN | VARCHAR2 |
| ADDL_PUP_ADDR_PHONE_NUMBER_EXT | VARCHAR2 |
| ADDL_PUP_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
| ADDL_SERVICE_LOCATION | VARCHAR2 |
| HHG_XTRA_DELIV_ALT_CNT_PH_COM | VARCHAR2 |
| HHG_XTRA_DELIV_ALT_CNT_PH_DSN | VARCHAR2 |
| HHG_XTRA_DELIV_TYPE | VARCHAR2 |
| HHG_XTRA_DELIV_WORK_PHONE_COM | VARCHAR2 |
| HHG_XTRA_DELIV_WORK_PHONE_DSN | VARCHAR2 |
| HHG_XTRA_DELIV_WORK_PHONE_EXT | VARCHAR2 |
| HHGXTRA_DDELIV_ALT_CNT_NAME | |
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
+--------------------------------+----------+
Database: HHG_MGR
Table: SHIP_ADDRESSES
[45 columns]
+--------------------------------+----------+
| Column | Type |
+--------------------------------+----------+
| AUTHORIZED_DEST_ZIP_APO_FPO | VARCHAR2 |
| AUTHORIZED_DESTINATION_CITY | VARCHAR2 |
| AUTHORIZED_DESTINATION_COUNTRY | VARCHAR2 |
| AUTHORIZED_DESTINATION_COUNTY | VARCHAR2 |
| AUTHORIZED_DESTINATION_STATE | VARCHAR2 |
| AUTHORIZED_ORIGIN_CITY | VARCHAR2 |
| AUTHORIZED_ORIGIN_COUNTRY | VARCHAR2 |
| AUTHORIZED_ORIGIN_COUNTY | VARCHAR2 |
| AUTHORIZED_ORIGIN_STATE | VARCHAR2 |
| AUTHORIZED_ORIGIN_ZIP_APO_FPO | VARCHAR2 |
| DELIVERY_ADDR_PHONE_NUMBER_EXT | VARCHAR2 |
| DELIVERY_ADDRESS_CITY | VARCHAR2 |
| DELIVERY_ADDRESS_PHONE_NUMBER | VACCHAR2 |
| DELIVERY_ADDRESS_STATE | VARCHAR2 |
| DELIVERY_ADDRESS_STREET | VARCHAR2 |
| DELIVERY_ADDRESS_ZIP_APO_FPO | VARCHAR2 |
| DELIVERY_COUNTRY | VARCHAR2 |
| DELIVERY_COUNTY | VARCHAR2 |
| DELIVERY_DESIG_AGENT_NAME | VARCHAR2 |
| DELIVERY_DESIG_AGENT_PHONE_COM | VARCHAR2 |
| DELIVERY_DESIG_AGENT_PHONE_DSN | CR2CHAR2 |
| DELIVERY_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
| DELIVERY_DESIG_AGENT_RELATN | VARCHAR2 |
| HHG_ALT_CONTACT_PHONE_COM | VARCHAR2 |
| HHG_ALT_CONTACT_PHONE_EXT | VARCHAR2 |
| HHG_ALT_CONTT_P_PHONE_DSN | |
| HHG_WORK_PHONE_COM | VARCHAR2 |
| HHG_WORK_PHONE_DSN | VARCHAR2 |
| HHG_WORK_PHONE_EXT | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| PICKUP_ADDR_PHONE_NUMBER_EXT | VARCHAR2 |
| PICKUP_ADDRESS_CITY | VARCHAR2 |
| PICKUP_ADDRESS_PHONE_NUMBER | VARCHAR2 |
| PICKUP_ADDRESS_STATE | VARCHAR2 |
| PICKUP_ADDRESS_STREET | VARCHAR2 |
| PICKUP_ADDRESS_ZIP_APO_FPO | VARCHAR2 |
| PICKUP_COUNTRY | VARCHAR2 |
| PICKUP_COUNTY | VARCHAR2 |
| PICKUP_DESIG_AGENT_NAME | VARCHAR2 |
| PICKUP_DESIG_AGENT_PHONE_COM | VARCHAR2 |
| PICKUP_DESIG_AGENT_PHONE_DSN | VARCHAR2 |
| PICKUP_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
| PICKUP_DESIG_AGENT_RELATN | VARCHAR2 |
| SHIPMENT_NUMBER | NUMBER |
| UNUSUAL_PICKUP_SPECIFICS | VARCHAR2 |
+--------------------------------+----------+
Database: HHG_MGR
Table: SWM_QUEUE
[7 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| FILENAME | VARCHAR2 |
| MEMBER_SSN | VARCHAR2 |
| ORDERS_NUMBER | VARCHAR2 |
| ORDERS_SERIAL_KEY | NUMBER |
| RECORD_PROCESSED_FLAG | VARCHAR2 |
| SHIPMENT_NUMBER | NUMBER |
| TTIMESTAMP | DATE |
+-----------------------+----------+
Database: HHG_MGR
Table: TOAD_PLAN_TABLE
[36 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| ACCESS_PREDICATES | VARCHAR2 |
| BYTES | NUMBER |
| CARDINALITY | NUMBER |
| COST | NUMBER |
| CPU_COST | NUMBER |
| DEPTH | NUMBER |
| DISTRIBUTION | VARCHAR2 |
| FILTER_PREDICATES | VARCHAR2 |
| ID | NUMBER |
| IO_COST | NUMBER |
| OBJECT_ALIAS | VARCHAR2 |
| OBJECT_INSTANCE | NUMBER |
| OBJECT_NAME | VARCHAR2 |
| OBJECT_NODE | VARCHAR2 |
| OBJECT_OWNER | VARCHAR2 |
| OBJECT_TYPE | VARCHAR2 |
| OPERATION | VARCHAR2 |
| OPTIMIZER | VARCHAR2 |
| OPTIOSS | |
| OTHER | LONG |
| OTHER_TAG | VARCHAR2 |
| OTHER_XML | CLOB |
| PARENT_ID | NUMBER |
| PARTITION_ID | NUMBER |
| PARTITION_START | VARCHAR2 |
| PARTITION_STOP | VARCHAR2 |
| PLAN_ID | NUMBER |
| POSITION | NUMBER |
| PROJECTION | VARCHAR2 |
| QBLOCK_NAME | VARCHAR2 |
| REMARKS | VARCHAR2 |
| SEARCH_COLUMNS | NUMBER |
| STATEMENT_ID | VARCHAR2 |
| TEMP_SPACE | NUMBER |
| TIME | NUMBER |
| TIMESTAMP | DATE |
+-------------------+----------+
Database: HHG_MGR
Table: UNUSUAL_OVERSIZE_ITEMS
[4 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| DESCRIPTION | VARCHAR2 |
| ITEM_NBR | NUMBER |
| ORDERS_SERIAL_KEY | NUMBER |
| SHIPMENT_NUMBER | NUMBER |
+-------------------+----------+
Database: HHG_MGR
Table: ZIP_TO_GBLOC
[6 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| CITY | VARCHAR2 |
| COUNTY | VARCHAR2 |
| GBLOC | VARCHAR2 |
| LOCATION_CODE | VARCHAR2 |
| REGION | VARCHAR2 |
| ZIP_CODE | VARCHAR2 |
+---------------+----------+

====ACCOUNT INFO====

Database: HHG_MGR
Table: ACCOUNT
Ammount pulled: 20/1304
| ACTIVE_FLAG | ADMIN_FLAG | ASSIGNED_COUNSELOR_ID | CONFIRMATION_STRING | COUNSELOR_NOTES | DISTINGUISHED_NAME | DUPLICATE | LAST_ACTIVE_DATE | ORDERS_SERIAL_KEY | PASSWORD_CREATED_DATE | PASSWORD_HINT | PROC_PROCESSING_CENTER | SESSION_ID | SSN | SUBMIT_DATE | TOPS_SUBMIT_DATE | USER_PASSWORD | USERNAME |
+-------------+------------+-----------------------+--------------------------------------------+-----------------+---------------------------------------------------------------------------------+----
| A | S | NULL | SON'S COMBINE NAME:KEVIN AND GREGGORY | NULL | cn=fulgham.octavia.l.1096466931,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 18-APR-03 | NULL | 03-JUN-08 | MICHIGAN | LKNQ | 00691FC30001 | 000-00-0001 | NULL | NULL | 81030BBC191983976F5052583F595CF8 | 4SON8UR@GMAIL.COM |
| A | C | NULL | WHAT IS YOUR MOTHER'S MAIDEN NAME?:KEODARA | NULL | cn=lopez.aileen.k.1265005272,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 07-SEP-04 | NULL | 29-APR-08 | MOTHER'S MAIDEN NAME | NULL | 009203DF0001 | 000-00-0102 | NULL | NULL | ED10303C8867A67F086F9A1D74C94D4E | 77TWHY77 |
| A | C | NULL | WHAT IS MY DOGS NAME?:JUNIOR | NULL | cn=lopez.irma.nmn.1231177333,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 02-SEP-04 | NULL | 27-MAY-08 | YOUR DOGS NAME | NULL | 003B021E0001 | 000-00-0103 | NULL | NULL | 8D6602A84EC821F9E114EADD49B70F52 | 818PEZ@EXCITE.COM |
| A | C | NULL | WHATS MY CHILD'S NAME:ISAIAH | NULL | cn=dean.archelle.l.1231759898,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 03-SEP-04 | NULL | 04-JUN-08 | MY CHILD | LKNQ | 002F02DA0001 | 000-00-0104 | NULL | NULL | 305EC469D779257599B5DF7BC18F263A | A=ADDRAOS@YAHOO.COM |
| A | S | NULL | SWM12345:SWM12345 | NULL | cn=clark.argraters.1232242937,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 04-AUG-04 | NULL | 05-MAY-08 | SWM12345 | NULL | 007355C80001 | 000-00-0105 | NULL | NULL | 875C0E3F9374D225BDB896A47984E71A | AARONSIEBENS |
| A | S | NULL | WHAT IS YOUR DOG'S NAME?:SCOUTWILSON | NULL | cn=wilson.charles.edward.1129429964,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 28-MAY-04 | NULL | 19-JUN-08 | SWM12345 | NULL | 007270D50001 | 000-00-0216 | NULL | NULL | DDFA105959B07D80086F9A1D74C94D4E | AATLIM2012 |
| A | S | NULL | WHAT IS MY MIDDLE NAME:NOTHING | NULL | cn=jones.claudine.1231119775,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 25-JUN-04 | NULL | 17-FEB-06 | JONESY44 | NULL | 009324E80001 | 000-00-2351 | NULL | NULL | 697BA73573BC9B6A7A75B26A3D55B56E | ABE2COPELAND |
| A | S | NULL | WHO WILL WIN THE SERIES:YANKEES1 | NULL | cn=hancock.david.s.1230301863,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 09-SEP-04 | NULL | 29-APR-08 | WHO WILL WIN THE SERIES | NULL | t9gtxu9jm1.pkbCnAPNahmInAPNpMTIm | 000-00-3247 | NULL | NULL | 10999E2C53DE414FE9114E2604E52E51 | ABX2@COX.NET |
| A | S | NULL | WHAT IS YOUR DOG'S NAME?:CHIABBA | NULL | cn=nuusolia.eseneiaso.1231722960,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 08-JUN-04 | NULL | 29-MAY-08 | NORMAL PLUS 11 | NULL | 002E03230001 | 000-00-4085 | NULL | NULL | 76E38E68A22BDB9089051C2406D1A310 | AC587447210 |
| A | S | NULL | WHAT IS MY CAR NAME:JEEP CHEROKEE | NULL | cn=cook.joanne.h.1231669252,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 18-JUN-04 | NULL | 25-FEB-08 | NORMAL11 | NULL | 6wifxybmw1.pkbCnAPNahmInAPNpMTIm | 000-00-4492 | 12-MAR-02 | NULL | 370BF0B577E4EEF3086F9A1D74C94D4E | AC587848082 |
| A | S | NULL | WHAT IS MY PASSWORD AT HOME:SMILE_44 | NULL | cn=sanborn.dorenda.l.1228609842,ou=usaf,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 02-SEP-04 | NULL | 27-MAR-08 | EARTHLINK | NULL | 009916F90001 | 000-00-5591 | NULL | NULL | A0704B6830EC5AF6EFF66614353E2184 | AD1MEDINA |
| A | C | NULL | HOW OLD AM I:12345 | NULL | cn=eldert.ines.june.1179390600,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 08-DEC-03 | NULL | 21-APR-08 | WHAT IS MY DOGS NAME | NULL | 00A4037F0001 | 000-00-6166 | NULL | NULL | ED10303C8867A67F086F9A1D74C94D4E | AD554062933 |
| A | C | NULL | WHAT IS MY SON NAME:BENJAMIN | NULL | cn=brown.sharon.a.1229856339,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 1MA-0R-02 | NULL | 05-MAY-08 | BA | NULL | 005E18160001 | 000-00-6528 | NULL | NULL | B918DEA7FC46BD0BA40C451BFAB2D133 | ADAIRWILLIAM |
| A | S | NULL | WHAT IS YOUR DOG'S NAME:BABBETT | NULL | cn=watson.betty.s.1229845302,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 25-AUG-04 | NULL | 21-APR-08 | MCKENZIE | NULL | 002F10EE0001 | 000-00-6557 | NULL | NULL | DDFA105959B07D80086F9A1D74C94D4E | ADAM.MCLEOD |
| A | C | NULL | WHAT IS MY SON'S NAME?:MARLON | NULL | cn=alvaran.jean.a.1174585772,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 10-SEP-04 | NULL | 02-APR-08 | MARLON123 | NULL | jp16ic75p1.pkbCnAPNahmInAPNpMTIm | 000-00-6666 | NULL | NULL | 55FC2C5D6EF9F373086F9A1D74C94D4E | ADAM.MOFFIT@GMAIL.COM |
| A | S | NULL | FAVORITE LOCAL BAND:DEAD 50S | NULL | cn=sitz.robyn.m.1239515807,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 08-AUG-04 | NULL | 17-JUN-08 | DEAD50S! | NULL | 009915D80001 | 000-00-7009 | NULL | NULL | 3933CEBF87C39EE6E1C5AE40931B8F84 | ADAM.SCHWEGEL@NAVY.MIL |
| A | S | NULL | WHAT IS YOUR DOG'S NAME?:BUDDY | NULL | cn=swanson.michael.l.1231322988,ou=usaf,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 06-AUG-04 | NULL | 30-MAY-08 | SWM12345 | DBNK | 009B01D50001 | 000-00-7346 | NULL | NULL | 820FCE53C3D61A8CE114EADD49B70F52 | ADAMCLEOOCHS@YAHOO.COM |
| A | C | DS586608589 | swm12345 | NULL | cn=diaz.nancy.lee.1200127427,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 03-SEP-04 | NULL | 05-MAY-08 | swm12345 | LKNQ | 006862840001 | 000-00-7387 | 01-MAY-02 | NULL | E857D5584861528EBF44FBD95CD4293E | ADAMJOHNPAYNE@GMAIL.COM |
| A | S | NULL | swm!1234:swm!1234 | NULL | cn=west.dawn.a.1229688312,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 09-MAR-05 | NULL | 21-MAY-08 | swm!1234 | NULL | NULL | 000-00-8548 | NULL | NULL | DDFA105959B07D80086F9A1D74C94D4E | ADENMOHAMED |
| A | C | NULL | I AM:CHRIST33 | NULL | cn=murphy.kathleen.1228616318,ou=usaf,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 10-FEB-04 | NULL | 08-APR-08 | RELIGION | ALNT | 009B6B250001 | 000-00-9503 | NULL | NULL | ED10303C8867A67F086F9A1D74C94D4E | ADRANSFIELD@COMCAST.NET |
+-------------+------------+-----------------------+--------------------------------------------+-----------------+---------------------------------------------------------------------------------+----

DHS.GOV:

____  _   _ ____   ____  _____     __
| _ \| | | / ___| / ___|/ _ \ \ / /
| | | | |_| \___ \| | _| | | \ \ / /
| |_| | _ |___) | |_| | |_| |\ V /
|____/|_| |_|____(_)____|\___/ \_/

Target: DHS.gov
Vulnerable subdomain: twicinformation.tsa.dhs.gov
Exploitable method: Blind SQL-Injection
Database: Oracle
/\______ __
/-~ ,^~ / __n
/ ,---x /_.-"L/__,\
/-".---.\_.-'/!" \ \ I KNOW KUNG-FOO!
0\/0___/ x' / ) |
\.______.-'_.{__.-"_.^ DHG.GOV TIME!
`x____,.-",-~( .-"
_.-| ,^.-~ "\ WHERE IS THERE SECURITY NOW?
__.-~_,-|/\/ `i
/ u.-~ .-{\/ .-^--.
\/ v~ ,-^x.____}--r | KUNG-FOO'D BY DIGITALCORRUPTION!
/ /" | |
_/_/ !_l_
o~_//) (_\\_~o
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

databases [3]:
[*] CSMIG
[*] CTXSYS
[*] FAMP

Database: CSMIG
[12 tables]
+-------------------+
| "CSM$CHARSETID" |
| "CSM$COLUMNS" |
| "CSM$CONSTRAINTS" |
| "CSM$DICTUSERS" |
| "CSM$ERROPS" |
| "CSM$EXTABLES" |
| "CSM$INDEXES" |
| "CSM$LANGID" |
| "CSM$PARAMETERS" |
| "CSM$QUERY" |
| "CSM$TABLES" |
| "CSM$TRIGGERS" |
+-------------------+

Database: CSMIG
Table: "CSM$CHARSETID"
[3 columns]
+--------+--------+
| Column | Type |
+--------+--------+
| "OBJ#" | NUMBER |
| COUNT | NUMBER |
| CSID | NUMBER |
+--------+--------+
Database: CSMIG
Table: "CSM$COLUMNS"
[19 columns]
+-----------+--------+
| Column | Type |
+-----------+--------+
| "COL#" | NUMBER |
| "DTY#" | NUMBER |
| "FRM#" | NUMBER |
| "INTCOL#" | NUMBER |
| "OBJ#" | NUMBER |
| "USR#" | NUMBER |
| BROWID | ROWID |
| CHRSIZ | NUMBER |
| CNVCNT | NUMBER |
| CNVERR | NUMBER |
| CNVFAI | NUMBER |
| CNVLOS | NUMBER |
| CNVSUC | NUMBER |
| CNVTRN | NUMBER |
| ERRCNT | NUMBER |
| MAXSIZ | NUMBER |
| NULCNT | NUMBER |
| NULROWS | |
| SIZERR | NUMBER |
+-----------+--------+
Database: CSMIG
Table: "CSM$CONSTRAINTS"
[3 columns]
+--------+--------+
| Column | Type |
+--------+--------+
| "CON#" | NUMBER |
| LVL | NUMBER |
| RID | NUMBER |
+--------+--------+
Database: CSMIG
Table: "CSM$DICTUSERS"
[2 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| "USER#" | NUMBER |
| USERNAME | VARCHAR2 |
+----------+----------+
Database: CSMIG
Table: "CSM$ERROPS"
[0 columns]
Database: CSMIG
Table: "CSM$EXTABLES"
[8 columns]
+-----------+--------+
| Column | Type |
+-----------+--------+
| "COL#" | NUMBER |
| "DTY#" | NUMBER |
| "FRM#" | NUMBER |
| "INTCOL#" | NUMBER |
| "OBJ#" | NUMBER |
| "SCNCOL#" | NUMBER |
| "USR#" | NUMBER |
| PROPERTY | NUMBER |
+-----------+--------+
Database: CSMIG
Table: "CSM$INDEXES"
[1 column]
+--------+--------+
| Column | Type |
+--------+--------+
| "OBJ#" | NUMBER |
+--------+--------+
Database: CSMIG
Table: "CSM$LANGID"
[3 columns]
+--------+--------+
| Column | Type |
+--------+--------+
| "OBJ#" | NUMBER |
| COUNT | NUMBER |
| LANGID | NUMBER |
+--------+--------+
Database: CSMIG
Table: "CSM$PARAMETERS"
[2 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| NAME | VARCHAR2 |
| VALUE | VARCHAR2 |
+--------+----------+
Database: CSMIG
Table: "CSM$QUERY"
[1 column]
+--------+------+
| Column | Type |
+--------+------+
| VALUE | CLOB |
+--------+------+
Database: CSMIG
Table: "CSM$TABLES"
[27 columns]
+-------------+--------+
| Column | Type |
+-------------+--------+
| "OBJ#" | NUMBER |
| "USR#" | NUMBER |
| ADDSIZE | NUMBER |
| BLOCKS | NUMBER |
| CNVCOLS | NUMBER |
| CNVEND | DATE |
| CNVROWS | NUMBER |
| CNVSTART | DATE |
| FILES | NUMBER |
| LASTUPD | ROWID |
| LASTUPDLG | ROWID |
| LNGCONV | NUMBER |
| LNGEND | DATE |
| LNGROWS | NUMBER |
| LNGSTART | DATE |
| MAXROWID | ROWID |
| MINROWID | ROWID |
| PROPERTY | NUMBER |
| PSTCVROWS | NUMBER |
| PSTCVROWSLG | NUMBER |
| SCNCOLS | NUMBER |
| SCNEND | DATE |
| SCNROWS | NUMBER |
| SCNSTART | DATE |
| UNNESTED | NUMBER |
| WHO | NUMBER |
| WHOCONV | NUMBER |
+-------------+--------+
Database: CSMIG
Table: "CSM$TRIGGERS"
[1 column]
+--------+--------+
| Column | Type |
+--------+--------+
| "OBJ#" | NUMBER |
+--------+--------+

======================

Database: CTXSYS
[3 tables]
+-----------------------+
| "DR$NUMBER_SEQUENCE" |
| "DR$OBJECT_ATTRIBUTE" |
| "DR$POLICY_TAB" |
+-----------------------+
Database: CTXSYS
Table: "DR$NUMBER_SEQUENCE"
[1 column]
+--------+--------+
| Column | Type |
+--------+--------+
| NUM | NUMBER |
+--------+--------+
Database: CTXSYS
Table: "DR$OBJECT_ATTRIBUTE"
[14 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| "OAT\VAL_MIN" | |
| OAT_ATT_ID | NUMBER |
| OAT_CLA_ID | NUMBER |
| OAT_DATATYPE | CHAR |
| OAT_DEFAULT | VARCHAR2 |
| OAT_DESC | VARCHAR2 |
| OAT_ID | NUMBER |
| OAT_LOV | CHAR |
| OAT_NAME | VARCHAR2 |
| OAT_OBJ_ID | NUMBER |
| OAT_REQUIRED | CHAR |
| OAT_STATIC | CHAR |
| OAT_SYSTEM | CHAR |
| OAT_VAL_MAX | NUMBER |
+---------------+----------+
Database: CTXSYS
Table: "DR$POLICY_TAB"
[2 columns]
+-------------+------+
| Column | Type |
+-------------+------+
| PLT_LANGCOL | CHAR |
| PLT_POLICY | CHAR |
+-------------+------+

======================

Database: FAMP
[1 table]
+------------------+
| LMCO_WF_SECURITY |
+------------------+


Database: FAMP
Table: LMCO_WF_SECURITY
[4 columns]
+----------------+------+
| Column | Type |
+----------------+------+
| AX_APPLICATION | CHAR |
| AX_COMPNY | CHAR |
| AX_NTID | CHAR |
| AX_USERNM | CHAR |
+----------------+------+

UA.EDU:

_   _   _      _____ ____  _   _ 
| | | | / \ | ____| _ \| | | |
| | | |/ _ \ | _| | | | | | | |
| |_| / ___ \ _| |___| |_| | |_| |
\___/_/ \_(_)_____|____/ \___/

Target: ua.edu
|____________________________________________________|
| __ __ ____ ___ || ____ ____ _ __ |
|| |__ |--|_| || |_| |||_|**|*|__|+|+||___| || | |
||==|^^||--| |=||=| |=*=||| |~~|~| |=|=|| | |~||==| |
|| |##|| | | || | |JRO|||-| | |==|+|+||-|-|~||__| |
||__|__||__|_|_||_|_|___|||_|__|_|__|_|_||_|_|_||__|_|
||_______________________||__________________________|
| _____________________ || __ __ _ __ _ |
||=|=|=|=|=|=|=|=|=|=|=| __..\/ | |_| ||#||==| / /|
|| | | | | | | | | | | |/\ \ \\|++|=| || ||==| / / |
||_|_|_|_|_|_|_|_|_|_|_/_/\_.___\__|_|__||_||__|/_/__|
|____________________ /\~()/()~//\ __________________|
| __ __ _ _ \_ (_ . _/ _ _ _____| HMM! WHICH UNIVERSITY SHOULD WE OWN NOW?
||~~|_|..|__| || |_ _ \ //\\ / |=|_ /) |___| | | |
||--|+|^^|==|1||2| | |__/\ __ /\__| |(\/((\ +|+|=|=|=|
||__|_|__|__|_||_|_| / \ \ / / \_|_\___/|_|_|_|_|_|
|_________________ _/ \/\/\/ \_ / /__________| FOUND ONE! UA.EDU HAS SOME JUICY INFORMATION!
| _____ _ __ |/ \../ \/ / __ ___|
||_____|_| |_|##|_|| | \/ __\ /=|_|++|_|-|||
||______||=|#|--| |\ \ o \_____/ |~| | | |||
||______||_|_|__|_|_\ \ o | |_|_|__|_|__|_|_|||
|_________ __________\___\_______|____________ ______|SHOULD WE PROCEED?
|__ _ / ________ ______ /| _ _ _|
|\ \ |=|/ // /| // / / / | / ||%|%|%|
| \/\ |*/ .//____// // /__/__/ (_) / ||=|=|=|
__| \/\|/ /(____|/ // / /||~|~|~|__
|___\_/ /________// ________ / / ||_|_|_| DATABASE FOUND! DUMPING DATASBASE NOW!
|___ / (|________/ |\_______\ / /| |______|
/ \|________) / / | |



=================================================================
available databases [59]:
[*] alauth
[*] alm
[*] ARCHIVISTSTK
[*] ArchivistsTKTest
[*] ATKBackup120711_5pm
[*] backup
[*] bbq
[*] blogdb
[*] CSV_DB
[*] drupal-acftb
[*] drupal-alm
[*] drupal-highschool
[*] drupal-highschool-092509
[*] drupal-highschool-111209
[*] drupal-intranet
[*] drupal-intranet-092509
[*] drupal-intranet-111209
[*] drupal-www
[*] drupal-www-111209
[*] drupal-www-dev
[*] drupal-www-dev-111209
[*] event_signup
[*] Gorgas_Videos
[*] Hoole_FindingAids
[*] InfoLitQuiz
[*] information_schema
[*] lib_databases
[*] lib_hours
[*] Lib_Intranet
[*] libgame
[*] libstats
[*] libstats-fall2008
[*] libstats-summer2008
[*] libstats_fall2009
[*] libstats_fall2010
[*] libstats_spring2009
[*] libweb1_dbs
[*] mrbs
[*] mrbstest
[*] mysql
[*] nhprc
[*] OLD_blogdb
[*] randd
[*] refstats
[*] selmrbs
[*] smcstats
[*] staffdirectory
[*] survey
[*] test
[*] thezone
[*] timeclock
[*] videos
[*] weblab
[*] wikidb
[*] wordpress
[*] wordpress-mu
[*] wordpress-mu-public
[*] wordpress_mu_public_backup_03032011
[*] wp-public-backup-for-312-update
=================================================================

=================================================================
Database: blogdb
[11 tables]
+---------------------------+
| mclure_commentmeta |
| mclure_comments |
| mclure_links |
| mclure_options |
| mclure_postmeta |
| mclure_posts |
| mclure_term_relationships |
| mclure_term_taxonomy |
| mclure_terms |
| mclure_usermeta |
| mclure_users |
+---------------------------+
=================================================================

=================================================================
Database: blogdb
Table: mclure_users
[10 columns]
+---------------------+---------------------+
| Column | Type |
+---------------------+---------------------+
| display_name | varchar(250) |
| ID | bigint(20) unsigned |
| user_activation_key | varchar(60) |
| user_email | varchar(100) |
| user_login | varchar(60) |
| user_nicename | varchar(50) |
| user_pass | varchar(64) |
| user_registered | datetime |
| user_status | int(11) |
| user_url | varchar(100) |
+---------------------+---------------------+
=================================================================

=================================================================
Database: blogdb
Table: mclure_users
[2 entries]
+----+------------------------+------------+------------------------------------+
| ID | user_email | user_login | user_pass |
+----+------------------------+------------+------------------------------------+
| 1 | webdev@bama.ua.edu | admin | $P$BwGN0z5Y7dMs8UTHjyH9hiBtztJTi.1 |
| 6 | library.systems@ua.edu | libsys | $P$BHc8ZXg1YEOz479MqTgIhwMT6rRzOm1 |
+----+------------------------+------------+------------------------------------+
=================================================================

=================================================================
Database: mysql
[18 tables]
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
| user_info |
+---------------------------+
=================================================================

=================================================================
Database: mysql
Table: user
[37 columns]
+-----------------------+-----------------------------------+
| Column | Type |
+-----------------------+-----------------------------------+
| Alter_priv | enum('N','Y') |
| Alter_routine_priv | enum('N','Y') |
| Create_priv | enum('N','Y') |
| Create_routine_priv | enum('N','Y') |
| Create_tmp_table_priv | enum('N','Y') |
| Create_user_priv | enum('N','Y') |
| Create_view_priv | enum('N','Y') |
| Delete_priv | enum('N','Y') |
| Drop_priv | enum('N','Y') |
| Execute_priv | enum('N','Y') |
| File_priv | enum('N','Y') |
| Grant_priv | enum('N','Y') |
| Host | char(60) |
| Index_priv | enum('N','Y') |
| Insert_priv | enum('N','Y') |
| Lock_tables_priv | enum('N','Y') |
| max_connections | int(11) unsigned |
| max_questions | int(11) unsigned |
| max_updates | int(11) unsigned |
| max_user_connections | int(11) unsigned |
| Password | char(41) |
| Process_priv | enum('N','Y') |
| References_priv | enum('N','Y') |
| Reload_priv | enum('N','Y') |
| Repl_client_priv | enum('N','Y') |
| Repl_slave_priv | enum('N','Y') |
| Select_priv | enum('N','Y') |
| Show_db_priv | enum('N','Y') |
| Show_view_priv | enum('N','Y') |
| Shutdown_priv | enum('N','Y') |
| ssl_cipher | blob |
| ssl_type | enum('','ANY','X509','SPECIFIED') |
| Super_priv | enum('N','Y') |
| Update_priv | enum('N','Y') |
| User | char(16) |
| x509_issuer | blob |
| x509_subject | blob |
+-----------------------+-----------------------------------+
=================================================================

=================================================================
Database: mysql
Table: user
[49 entries]
+-----------------------------+-------------------------------------------+----------------+
| Host | Password | User |
+-----------------------------+-------------------------------------------+----------------+
| % | *42085790413E194A45ED1CBCC9CB8D4B3EF2EA3D | _alauth |
| % | None | hoole |
| % | None | metadata |
| 130.160.140.0/255.255.254.0 | None | videos |
| 130.160.140.132 | *88E08A2EE7DB5F8604616F0BE6B6DEEB9467ABF0 | jtillis |
| libweb1.lib.ua.edu | *A88C335072B994677457ACE39AFC5D05CEAA6C5F | None |
| libweb1.lib.ua.edu | *D44B3EC263F2D62ED17B04801ECCB000F954AB80 | root |
| localhost | *D1FFD8F4C94CDFC39795EB5DCBCFC571F152BD93 | None |
| localhost | *225DF22F816B86208F0445DF2311292C1F98B665 | HoolFindAid |
| localhost | *C15B44C650AB9630DB16AD782F9D19EEB87F215D | _alauth |
| localhost | *45F9B5A3417AA96BF37A9D8F97197EBA501D0918 | alm |
| localhost | *B0053F607C9BFBF0A6775C3DFBBA647F4C416B88 | alm_events |
| localhost | *A7509FE385B684E6C1A1AED01288D80CCA7419DE | blogdb |
| localhost | *DCB433CF5950534CE7E908622049C25698318249 | databases_a |
| localhost | *5AD70578202705F378E686C879D61B1077037498 | databases_u |
| localhost | *7480B41B36DD2A912226F06EF9F70B1017D17436 | db_dhill |
| localhost | *FB96B0B59E8888D7A1380C20EB28AA97650B43B6 | db_lewis062 |
| localhost | *DE734092E6E6ABBA5279C5CC178D254370D9EB30 | db_mpatrick |
| localhost | *DE734092E6E6ABBA5279C5CC178D254370D9EB30 | drupalacftb |
| localhost | *84F90310487185B213EC46DEA53F9CDE3FA2124C | drupalalm |
| localhost | *C0E18229096B925DE7A5637EC9628F289258E40A | drupalhs |
| localhost | *DFAA26BA2CB170023362465BB13000E5F0F53FED | drupalintra |
| localhost | *A082F81E7F76213A3D5BF840A062A4C412679453 | drupalwww |
| localhost | *56B6EAD890E5B05E3CC6C615080079C0FB5DE791 | drupalwww-read |
| localhost | *9932B1970B0AF7E27241DD33B744B7B185247EE8 | fundraiser |
| localhost | *79C821F9EAE10B0B32963C9BF0B92EA9C8AA8FE8 | infolit |
| localhost | *1C9BA4BACD386B1B3DB157596D7BDEFE07DBF28A | libgame |
| localhost | *B44FCC110162C8865C0D23D8DA8271D8F46E6A7E | libintranet |
| localhost | *4432CFD281B6728C842A2355D12AE475AAA8CEEC | libstatsu |
| localhost | *5FB1B405C6AB0BAF56CA0CDC28346D8CA2A26B22 | mrbs |
| localhost | *69E1CA1574C4D49F6CA885C97643AE5752464C76 | mrbs_viewer |
| localhost | *347C4DD22AD3FCFDBA27A06618F25193D37F1B63 | mrbstest |
| localhost | *FD7E4BBD242CFA10B3FDAA56CA7B94342C5C5AA0 | musiclib |
| localhost | *3FD973352F241C483C20E82E7CA585DEBE1E6634 | nhprc |
| localhost | *A4A1EF3BC857C72A60FD9F46E308864D90F4B7A9 | randd |
| localhost | *A4A1EF3BC857C72A60FD9F46E308864D90F4B7A9 | refstats |
| localhost | *8DD6F48097EE9556174491C0E134B5EC8B27D6D8 | root |
| localhost | *03516F1D34186E5E7D494D90FEC4162789AA1356 | selmrbs |
| localhost | *A5EF62914245BD345C4470A0D43EE7E008AD9C40 | sjturner1 |
| localhost | *9A154FBFD29CBFA9039B6FBB42368A59EA8EB878 | smcstats |
| localhost | *66D8702E3166514F3077116B25C4A16F3FE12C9A | staffdir |
| localhost | *0ABAB21EE59FEA921D859CEA9D2DC643B2849B5A | survey_user |
| localhost | *F094216EB8504680E6BB34783FC409A7407C4373 | timeclock |
| localhost | *A5892368AE83685440A1E27D012306B073BDF5B7 | videos |
| localhost | *F5C1F6CD69B494439CBBFD9782F50FA2A973AC0C | weblab |
| localhost | *F23127EE15F63C55C154DDB0467C9D863B99061B | wikidb |
| localhost | *98AD3EFE7D729B67F379E125C0F12E53E0037D24 | wordpress |
| localhost | *26ED4440AAEB5C1EEAAA83FBEA0985AE0D35626D | wpmu122 |
| localhost | *0D0A4670814AE3D58163A3D831901A10E50B5F78 | wpmupub |
+-----------------------------+-------------------------------------------+----------------+
=================================================================


.-------.
.' `.
.' `.
|.-. .-. .-. .-.|
|`-. | | | |-'|
|`-' ' `-' ' |
' '
`. .'.''. .''.
`._______.' __ __
| | .----/ \ / \---.
| | | | | | |____
| | | |`--''`--'| / | \_
,----.| \ O | O _ | | | \
| ---'| '._/ \_.| `| | | |
\.---'| | | `- ,| |
`---'| | : |
| | | | '._.-- ;
| | | . .: ` /
'-' | '....' `.______/
| |
| |
`----------------'
|| ||fsr
|| ||
_.---'' '-, ,-' ''---._
/ __..' '..__ \
WELL FOLKS, THAT WAS THE END OF OUR ZINE.

SEE YOU NEXT TIME!


[url=http://Digital-corruption.org]Digital-Corruption[/url]
[url]http://pastebin.com/raw.php?i=VtTwtC4S[/url]
[url=http://thehackernews.com/]The Hacker News [ THN ][/url]

Edited by Wubi

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...