Results Reports version 02_01_00 Oct 6, 2004.

In DBQ01

Oracle

Use the RESULTSRPT Database Access.xls spreadsheet 
The grant statements for Procedures
 has been generated and the grant statements are in the output tab.

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

1) Update Existing Functions
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\fnc\RSLTRPT_GET_FCL_SPECS_AVG_AGE.FNC
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\fnc\RSLTRPT_GET_FCL_SPECS_AVG_HGHT.FNC
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\fnc\RSLTRPT_GET_FOR_COVR_SPEC_DATA.FNC


2) Create New Functions (Require Public Synonyms)
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\fnc\RSLTRPT_GET_SL_TREE_DATA.FNC
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\fnc\RSLTRPT_GET_STANDARDS_UNIT_ID.FNC

3) Create New Procedures (Require Public Synonyms)
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\prc\RSLTRPT_DATA001.PRC
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\prc\RSLTRPT_DATA002.PRC
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\prc\RSLTRPT_DATA003.PRC
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\prc\RSLTRPT_DATA004.PRC
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\prc\RSLTRPT_FG_STANDS_DECLARE.prc
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\prc\RSLTRPT_FG_STANDS_DECLARE_DTL.prc
   @S:\Test\resultsrpt\Oracle\02_01_00\ddl\prc\RSLTRPT_REGEN_SEEDLOT_VEG_USE.prc

4) Create Grants for the New Objects
   GRANT execute on RSLTRPT_GET_SL_TREE_DATA to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_GET_STANDARDS_UNIT_ID to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_DATA001 to CRS_RESULTSRPT_REPORTS;
   GRANT execute on RSLTRPT_DATA002 to CRS_RESULTSRPT_REPORTS;
   GRANT execute on RSLTRPT_DATA003 to CRS_RESULTSRPT_REPORTS;
   GRANT execute on RSLTRPT_DATA004 to CRS_RESULTSRPT_REPORTS;
   GRANT execute on RSLTRPT_FG_STANDS_DECLARE to CRS_RESULTSRPT_REPORTS;
   GRANT execute on RSLTRPT_FG_STANDS_DECLARE_DTL to CRS_RESULTSRPT_REPORTS;
   GRANT execute on RSLTRPT_REGEN_SEEDLOT_VEG_USE to CRS_RESULTSRPT_REPORTS;
   GRANT execute on RSLTRPT_DATA001 to CRS_RESULTSRPT_LIC_REPORTS;
   GRANT execute on RSLTRPT_DATA002 to CRS_RESULTSRPT_LIC_REPORTS;
   GRANT execute on RSLTRPT_DATA003 to CRS_RESULTSRPT_LIC_REPORTS;
   GRANT execute on RSLTRPT_DATA004 to CRS_RESULTSRPT_LIC_REPORTS;
   GRANT execute on RSLTRPT_FG_STANDS_DECLARE to CRS_RESULTSRPT_LIC_REPORTS;
   GRANT execute on RSLTRPT_FG_STANDS_DECLARE_DTL to CRS_RESULTSRPT_LIC_REPORTS;
   GRANT execute on RSLTRPT_REGEN_SEEDLOT_VEG_USE to CRS_RESULTSRPT_LIC_REPORTS;
   GRANT execute on RSLTRPT_DATA001 to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_DATA002 to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_DATA003 to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_DATA004 to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_FG_STANDS_DECLARE to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_FG_STANDS_DECLARE_DTL to CRS_WEB_INQUIRY;
   GRANT execute on RSLTRPT_REGEN_SEEDLOT_VEG_USE to CRS_WEB_INQUIRY;

