--This script creates the opdb user for the 
--AODB interface in to UltraTrak at SFO
connect system/dragon
create user opdb_user identified by opdb default tablespace user_default_tab;
grant connect to opdb_user;
grant create view to opdb_user;
grant execute on ops$tagtrak.pkg73_notify to opdb_user;
create synonym opdb_user.pkg73_notify for ops$tagtrak.pkg73_notify;
connect live/live
grant insert,update,select,delete on fasl_flight_info to opdb_user;
connect opdb_user/opdb
@@opdb_flight_info.sql
exit;
