-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 01_00_00
-- -------------------------------------------------------------------------------------
-- <2003/10/31> <DRV> For migration into <test> (<DBQ01>)

-- -------------------------------------------------------------------------------------
-- Migration Notes:

 - 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:
    @W:\FTARpt\install_scripts\pkgs.sql
    @W:\FTARpt\install_scripts\functions.sql
    @W:\FTARpt\install_scripts\procedures.sql
    @W:\FTARpt\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



-- -------------------------------------------------------------------------------------

