-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 01_00_03
-- -------------------------------------------------------------------------------------
-- <2003/12/24> <DBA> For migration into <test> (<DBQ01>)
-- 2004/02/04 JDL For migration into Production (DBP01)
-- -------------------------------------------------------------------------------------

These are required Pulldown and validation procedures and functions need to allow the 
reports to run in CRSRM

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

 - As per instructions: 

1) Run the scripts as listed in:
@S:\Test\ftarpt\Oracle\01_00_03\install_scripts\functions.sql
@S:\Test\ftarpt\Oracle\01_00_03\install_scripts\packages.sql
@S:\Test\ftarpt\Oracle\01_00_03\install_scripts\procedures.sql
@S:\Test\ftarpt\Oracle\01_00_03\install_scripts\views.sql

2) All of these Objects are New
   Create the Synonyms for the Objects

3) Grant priveledges
   The grants are listed on the output tab on the file:
   roles_users\grants.sql


-- -------------------------------------------------------------------------------------
-- 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

 - WebADE Entry migration from Test to Prod:

insert into BKUP_PROXY_CONTROL select * from PROXY_CONTROL where application_acronym = 'CRSRM' and role_name like 'FTARPT%';

delete from PROXY_CONTROL      where application_acronym = 'CRSRM';
delete from ACTION_LNK         where application_acronym = 'CRSRM';
delete from ACTION             where application_acronym = 'CRSRM';
delete from NT_GROUP           where application_acronym = 'CRSRM';
delete from APPLICATION_ROLE   where application_acronym = 'CRSRM';

insert into APPLICATION_ROLE   select * from APPLICATION_ROLE@DBQ01 where application_acronym = 'CRSRM';
insert into NT_GROUP           select * from NT_GROUP@DBQ01         where application_acronym = 'CRSRM';
insert into ACTION             select * from ACTION@DBQ01           where application_acronym = 'CRSRM';
insert into ACTION_LNK         select * from ACTION_LNK@DBQ01       where application_acronym = 'CRSRM';

insert into PROXY_CONTROL      select * from BKUP_PROXY_CONTROL     where application_acronym = 'CRSRM';

-- No changes to REPORT_PROXY_CONTROL this time.



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

