Rem
Rem $Header: sdogrtg.sql 21-mar-2008.11:28:57 hzhu Exp $
Rem
Rem sdogrtg.sql
Rem
Rem Copyright (c) 2002, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdogrtg.sql - GeoRaster TYPE Grant permissions to PUBLIC
Rem
Rem    DESCRIPTION
Rem      Grant execute permission to PUBLIC and create public sysnonyms 
Rem      for the GeoRaster types
Rem
Rem    NOTES
Rem     
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    hzhu        03/21/08 - Add georeferencing types
Rem    sravada     07/30/04 - add create/replace 
Rem    qxie        10/08/02 - rename and add new types
Rem    qxie        04/17/02 - add synonyms
Rem    wexu        04/22/02 - grant execute on SDO_NUMBER_ARRAY to public
Rem    qxie        04/08/02 - Created
Rem

Rem **************************************************************************
Rem THIS FILE MUST NOT BE MODIFIED BY THE CUSTOMER.  DOING SO
Rem COULD CAUSE INTERNAL ERRORS AND SECURITY VIOLATIONS IN THE DBMS.
Rem **************************************************************************
Rem
Rem It is assumed we are connected as MDSYS 
Rem

GRANT EXECUTE ON MDSYS.SDO_GEORASTER       to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_METADATA   to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_RASTER          to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_RASTERSET       to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_SRS        to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_HISTOGRAM  to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_GRAYSCALE  to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_COLORMAP   to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_NUMBER_ARRAY    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_STRING_ARRAY    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_GCP        to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_GCP_COLLECTION to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_GEOR_GCPGEOREFTYPE to PUBLIC WITH GRANT OPTION;

/*
DROP PUBLIC SYNONYM SDO_GEORASTER;
DROP PUBLIC SYNONYM SDO_GEOR_METADATA;
DROP PUBLIC SYNONYM SDO_RASTERSET;
DROP PUBLIC SYNONYM SDO_RASTER;
DROP PUBLIC SYNONYM SDO_GEOR_SRS;
DROP PUBLIC SYNONYM SDO_GEOR_HISTOGRAM;
DROP PUBLIC SYNONYM SDO_GEOR_GRAYSCALE;
DROP PUBLIC SYNONYM SDO_GEOR_COLORMAP;
DROP PUBLIC SYNONYM SDO_NUMBER_ARRAY;
DROP PUBLIC SYNONYM SDO_STRING_ARRAY;
*/

CREATE OR REPLACE PUBLIC SYNONYM SDO_GEORASTER      for MDSYS.SDO_GEORASTER;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_METADATA  for MDSYS.SDO_GEOR_METADATA;
CREATE OR REPLACE PUBLIC SYNONYM SDO_RASTER         for MDSYS.SDO_RASTER;
CREATE OR REPLACE PUBLIC SYNONYM SDO_RASTERSET      for MDSYS.SDO_RASTERSET;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_SRS       for MDSYS.SDO_GEOR_SRS;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_HISTOGRAM for MDSYS.SDO_GEOR_HISTOGRAM;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_GRAYSCALE for MDSYS.SDO_GEOR_GRAYSCALE;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_COLORMAP  for MDSYS.SDO_GEOR_COLORMAP;
CREATE OR REPLACE PUBLIC SYNONYM SDO_NUMBER_ARRAY   for MDSYS.SDO_NUMBER_ARRAY;
CREATE OR REPLACE PUBLIC SYNONYM SDO_STRING_ARRAY   for MDSYS.SDO_STRING_ARRAY;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_GCP       for MDSYS.SDO_GEOR_GCP;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_GCP_COLLECTION for MDSYS.SDO_GEOR_GCP_COLLECTION;
CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOR_GCPGEOREFTYPE for MDSYS.SDO_GEOR_GCPGEOREFTYPE;