/*****************************************************************************
*
* Filename         - $Workfile:   grnts.sql  $
*
*                     Name              Date      Version     CR Number
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle database)
*
* Source Code
* Identifier       - 0/3/300/8010/112
*
* Design Spec
* Section          - 
*
* Contents         - Temp schema: Grant permissions to other users
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/

grant all on bag to arch;
grant all on bag_alert to arch;
grant all on bag_trace to arch;
grant all on db_version to arch;
grant all on flight to arch;
grant all on flight_dests to arch;
grant all on flight_status to arch;
grant all on flight_trace to arch;
grant all on log_table to arch;
grant all on pax to arch;
grant all on ulds to arch;
grant all on uld_dests to arch;
grant all on uld_trace to arch;
grant all on stats to arch;
grant all on stats_access to arch;
grant all on flight_access to arch;
grant all on flight_events to arch;
grant all on flight_info to arch;
grant all on flight_info_inbound to arch;
grant all on flight_info_extras to arch;
grant all on mach_flight_info to arch;
grant all on hel_fids_flight_info to arch;
grant all on lba_info to arch;
grant all on hbmd to arch;
grant all on pm_results to arch;
grant all on eq_log to arch;

GRANT ALL ON inbound_pax TO arch;
GRANT ALL ON inbound_pax_onward_dests TO arch;
GRANT ALL ON inbound_uld TO arch;
GRANT ALL ON inbound_uld_dests TO arch;
GRANT ALL ON inbound_bag TO arch;

GRANT ALL ON messages TO arch;
GRANT ALL ON message_parts TO arch;
GRANT ALL ON messages_trace TO arch;

