Rem
Rem $Header: sdotypeg.sql 27-jun-2007.16:21:53 sravada Exp $
Rem $Header: sdotypeg.sql 27-jun-2007.16:21:53 sravada Exp $
Rem
Rem sdotypeg.sql
Rem
Rem Copyright (c) 1997, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdotypeg.sql - SDO TYPE Grant permissions to PUBLIC
Rem
Rem    DESCRIPTION
Rem      Grant execute permission to PUBLIC and create public sysnonyms 
Rem      for the type SDO_GEOMETRY
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    sravada     06/27/07 - 
Rem    bgouslin    01/07/07 - New version to fix Windoze format issue caused by
Rem                           some ADE bug
Rem    zzhang      02/06/06 - add SDO_STRING2_ARRAY
Rem    wexu        01/09/06 - add SDO_RANGE/SDO_RANGE_ARRAY 
Rem    rkothuri    04/26/04 - create synonyms for sdo_regaggr etc 
Rem    rkothuri    02/03/03 - change sdoridpair, sdoridset
Rem    rkothuri    11/05/02 - add sdo_regaggrset
Rem    rkothuri    10/01/02 - add sdo_rgn and rgnset
Rem    qxie        04/17/02 - grant privilege on number and string arrays
Rem    sravada     04/12/02 - add type synonyms
Rem    rkothuri    04/22/02 - add sdo_ridset
Rem    rkothuri    03/26/01 - add sdo_rid_Array
Rem    rkothuri    08/26/99 - add sdo_mbr
Rem    jsharma     09/16/98 - Remove synonyms for types
Rem    pfwang      05/19/98 - Linearize sdo_elem_object, add sdo_point_type
Rem    ranwei      01/20/98 - replace SDO_GID with ROWID in object interface
Rem    jsharma     12/22/97 - Add sdo_dim_element and sdo_dim_array types
Rem    jsharma     12/18/97 - Grant permissions to PUBLIC on SDO_GEOMETRY
Rem    jsharma     12/18/97 - 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
Rem

GRANT EXECUTE ON MDSYS.SDO_GEOMETRY         to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_ORDINATE_ARRAY   to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_POINT_TYPE       to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_ELEM_INFO_ARRAY  to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_DIM_ELEMENT      to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_DIM_ARRAY        to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_VPOINT_TYPE      to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_MBR              to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_ROWIDPAIR        to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_ROWIDSET         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_STRING2_ARRAY    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_STRING2_ARRAYSET to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_SMPL_GEOMETRY    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_REGION	    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_REGIONSET	    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_REGAGGR	    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_REGAGGRSET	    to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_RANGE            to PUBLIC WITH GRANT OPTION;
GRANT EXECUTE ON MDSYS.SDO_RANGE_ARRAY      to PUBLIC WITH GRANT OPTION;

Rem Synonyms are allowed on object types as of 9iR2
Rem But spatial is using them from 10i
Rem 

declare
begin
  begin
    execute immediate
      'CREATE OR REPLACE PUBLIC SYNONYM SDO_GEOMETRY for MDSYS.SDO_GEOMETRY';
    exception when others then NULL;
   end;
end;
/

CREATE OR REPLACE PUBLIC SYNONYM SDO_POINT_TYPE        for MDSYS.SDO_POINT_TYPE;
CREATE OR REPLACE PUBLIC SYNONYM SDO_ELEM_INFO_ARRAY   
                                    for MDSYS.SDO_ELEM_INFO_ARRAY;
CREATE OR REPLACE PUBLIC SYNONYM SDO_ORDINATE_ARRAY 
                                       for MDSYS.SDO_ORDINATE_ARRAY;

CREATE OR REPLACE PUBLIC SYNONYM SDO_DIM_ELEMENT     for MDSYS.SDO_DIM_ELEMENT;
CREATE OR REPLACE PUBLIC SYNONYM SDO_DIM_ARRAY       for MDSYS.SDO_DIM_ARRAY;
CREATE OR REPLACE PUBLIC SYNONYM SDO_VPOINT_TYPE     for MDSYS.SDO_VPOINT_TYPE;
CREATE OR REPLACE PUBLIC SYNONYM SDO_MBR	     for MDSYS.SDO_MBR;
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_STRING2_ARRAY    for MDSYS.SDO_STRING2_ARRAY;
CREATE OR REPLACE PUBLIC SYNONYM SDO_STRING2_ARRAYSET for MDSYS.SDO_STRING2_ARRAYSET;
CREATE OR REPLACE PUBLIC SYNONYM SDO_ROWIDPAIR	     for MDSYS.SDO_ROWIDPAIR;
CREATE OR REPLACE PUBLIC SYNONYM SDO_ROWIDSET	     for MDSYS.SDO_ROWIDSET;

CREATE OR REPLACE PUBLIC SYNONYM SDO_REGION 	     for MDSYS.SDO_REGION;
CREATE OR REPLACE PUBLIC SYNONYM SDO_REGIONSET 	     for MDSYS.SDO_REGIONSET;
CREATE OR REPLACE PUBLIC SYNONYM SDO_REGAGGR 	     for MDSYS.SDO_REGAGGR;
CREATE OR REPLACE PUBLIC SYNONYM SDO_REGAGGRSET      for MDSYS.SDO_REGAGGRSET;

CREATE OR REPLACE PUBLIC SYNONYM SDO_RANGE           for MDSYS.SDO_RANGE;
CREATE OR REPLACE PUBLIC SYNONYM SDO_RANGE_ARRAY     for MDSYS.SDO_RANGE_ARRAY;