Results Reports version 01_00_03 March 19, 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.

----------------------------------------------------------------
-- Already exists and is populated, by CRSRA
--1) Create New Table

--@S:\Test\resultsrpt\Oracle\01_00_03\ddl\PRIVATE_LAND_VOL_HA_RATIO_CONV.tab

--   Load data into the table

--@S:\Test\resultsrpt\Oracle\01_00_03\dml\ins_PRIVATE_LAND_VOL_HA_RATIO_CONV.sql


2) Create Procedures & Packages & Functions

@S:\Test\resultsrpt\Oracle\01_00_03\install_scripts\PKG.sql
@S:\Test\resultsrpt\Oracle\01_00_03\install_scripts\PRC.sql
@S:\Test\resultsrpt\Oracle\01_00_03\install_scripts\FNC.sql

3) Create Views

@S:\Test\resultsrpt\Oracle\01_00_03\install_scripts\VW.sql

4) Run Grants

@S:\test\resultsrpt\Oracle\01_00_03\roles_users\grants.sql
