-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 01_00_00 and 01_00_01 combined
-- -------------------------------------------------------------------------------------
-- <2003/10/31> <DRV> For migration into <test> (<DBQ01>)
-- <2003/11/26> <DRV> For migration into <prod> (<DBP01>)
-- -------------------------------------------------------------------------------------
-- Migration Notes:
 - combined two releases to function as below.

 - As per instructions: 

1) Create the roles and usernames listed in the 
   in the ..\roles_users\roles_users.sql file.

2) Run the scripts as listed in:
    @s:\prod\FTARpt\Oracle\01_00_01\install_scripts\packages.sql
    @s:\prod\FTARpt\Oracle\01_00_01\install_scripts\functions.sql
    @s:\prod\FTARpt\Oracle\01_00_01\install_scripts\procedures.sql
    @s:\prod\FTARpt\Oracle\01_00_01\install_scripts\views.sql

3) Create the Synonyms for the Objects

4) Grant priveledges
   The grants are listed on the output tab on the file:
   FTARPT Database Access.xls


-- -------------------------------------------------------------------------------------
-- DBA Changes to Original DDL:

-  generate public synonym list
-  review for invalids

-- -------------------------------------------------------------------------------------
-- Role/Security Notes: 

-  adjust WEBADE entries
-  check naming convensions and create the following proxy ids and roles



-- -------------------------------------------------------------------------------------
--..0....1....1....2....2....3....3....4....4....5....5....6....6....7....7....8
--..5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....0
-- This line is 80 characters long, this is the longest a script name can be ...
