-- Grants to an in-house Oracle account, 
-- that is used to input CERA data.
-- mind: the corresponding ORACLE Form "loadMDB"
--   does not work with any user 
--   different from "CERA". 
--                         ft, 1999.07.08
--
grant select on LOAD_CONTA to pik_public;
grant select on LOAD_COVER to pik_public;
grant select on LOAD_DISTR to pik_public;
grant select on LOAD_ENTRY to pik_public;
grant select on LOAD_KEY_C to pik_public;
grant select on LOAD_MODEL to pik_public;
grant select on LOAD_PARAM to pik_public;
grant select on LOAD_PROCE to pik_public;
grant select on LOAD_REFER to pik_public;
grant select on LOAD_SPATI to pik_public;
--
grant insert on LOAD_CONTA to pik_public;
grant insert on LOAD_COVER to pik_public;
grant insert on LOAD_DISTR to pik_public;
grant insert on LOAD_ENTRY to pik_public;
grant insert on LOAD_KEY_C to pik_public;
grant insert on LOAD_MODEL to pik_public;
grant insert on LOAD_PARAM to pik_public;
grant insert on LOAD_PROCE to pik_public;
grant insert on LOAD_REFER to pik_public;
grant insert on LOAD_SPATI to pik_public;
--
grant delete on LOAD_CONTA to pik_public;
grant delete on LOAD_COVER to pik_public;
grant delete on LOAD_DISTR to pik_public;
grant delete on LOAD_ENTRY to pik_public;
grant delete on LOAD_KEY_C to pik_public;
grant delete on LOAD_MODEL to pik_public;
grant delete on LOAD_PARAM to pik_public;
grant delete on LOAD_PROCE to pik_public;
grant delete on LOAD_REFER to pik_public;
grant delete on LOAD_SPATI to pik_public;
--
grant update on LOAD_CONTA to pik_public;
grant update on LOAD_COVER to pik_public;
grant update on LOAD_DISTR to pik_public;
grant update on LOAD_ENTRY to pik_public;
grant update on LOAD_KEY_C to pik_public;
grant update on LOAD_MODEL to pik_public;
grant update on LOAD_PARAM to pik_public;
grant update on LOAD_PROCE to pik_public;
grant update on LOAD_REFER to pik_public;
grant update on LOAD_SPATI to pik_public;
--
--
--
grant select on NEW_ACCESS_CONSTRAINT to pik_public;
grant select on NEW_ACCESS_STRUCTURE  to pik_public;
grant select on NEW_ACCESS_TYPE       to pik_public;
grant select on NEW_AGGREGATION       to pik_public;
grant select on NEW_CITATION          to pik_public;
grant select on NEW_CITATION_TYPE     to pik_public;
grant select on NEW_CONNECT_TYPE      to pik_public;
grant select on NEW_CONTACT_TYPE      to pik_public;
grant select on NEW_CURRENTNESS_REF   to pik_public;
grant select on NEW_ENTRY_TYPE        to pik_public;
grant select on NEW_FEES              to pik_public;
grant select on NEW_FORMAT            to pik_public;
grant select on NEW_GENERAL_KEY       to pik_public;
grant select on NEW_HOR_COORD_SYS     to pik_public;
grant select on NEW_INSTITUTE         to pik_public;
grant select on NEW_LOCATION          to pik_public;
grant select on NEW_MODEL             to pik_public;
grant select on NEW_MODEL_TYPE        to pik_public;
grant select on NEW_PERSON            to pik_public;
grant select on NEW_PRESENTATION      to pik_public;
grant select on NEW_PROGRESS          to pik_public;
grant select on NEW_PROJECT           to pik_public;
grant select on NEW_REF_TYPE          to pik_public;
grant select on NEW_SPATIAL_DATA_ORG  to pik_public;
grant select on NEW_STORAGE           to pik_public;
grant select on NEW_TOPIC             to pik_public;
grant select on NEW_UNIT              to pik_public;
grant select on NEW_USE_CONSTRAINT    to pik_public;
grant select on NEW_VER_COORD_SYS     to pik_public;
--
grant insert on NEW_ACCESS_CONSTRAINT to pik_public;
grant insert on NEW_ACCESS_STRUCTURE  to pik_public;
grant insert on NEW_ACCESS_TYPE       to pik_public;
grant insert on NEW_AGGREGATION       to pik_public;
grant insert on NEW_CITATION          to pik_public;
grant insert on NEW_CITATION_TYPE     to pik_public;
grant insert on NEW_CONNECT_TYPE      to pik_public;
grant insert on NEW_CONTACT_TYPE      to pik_public;
grant insert on NEW_CURRENTNESS_REF   to pik_public;
grant insert on NEW_ENTRY_TYPE        to pik_public;
grant insert on NEW_FEES              to pik_public;
grant insert on NEW_FORMAT            to pik_public;
grant insert on NEW_GENERAL_KEY       to pik_public;
grant insert on NEW_HOR_COORD_SYS     to pik_public;
grant insert on NEW_INSTITUTE         to pik_public;
grant insert on NEW_LOCATION          to pik_public;
grant insert on NEW_MODEL             to pik_public;
grant insert on NEW_MODEL_TYPE        to pik_public;
grant insert on NEW_PERSON            to pik_public;
grant insert on NEW_PRESENTATION      to pik_public;
grant insert on NEW_PROGRESS          to pik_public;
grant insert on NEW_PROJECT           to pik_public;
grant insert on NEW_REF_TYPE          to pik_public;
grant insert on NEW_SPATIAL_DATA_ORG  to pik_public;
grant insert on NEW_STORAGE           to pik_public;
grant insert on NEW_TOPIC             to pik_public;
grant insert on NEW_UNIT              to pik_public;
grant insert on NEW_USE_CONSTRAINT    to pik_public;
grant insert on NEW_VER_COORD_SYS     to pik_public;
--
grant delete on NEW_ACCESS_CONSTRAINT to pik_public;
grant delete on NEW_ACCESS_STRUCTURE  to pik_public;
grant delete on NEW_ACCESS_TYPE       to pik_public;
grant delete on NEW_AGGREGATION       to pik_public;
grant delete on NEW_CITATION          to pik_public;
grant delete on NEW_CITATION_TYPE     to pik_public;
grant delete on NEW_CONNECT_TYPE      to pik_public;
grant delete on NEW_CONTACT_TYPE      to pik_public;
grant delete on NEW_CURRENTNESS_REF   to pik_public;
grant delete on NEW_ENTRY_TYPE        to pik_public;
grant delete on NEW_FEES              to pik_public;
grant delete on NEW_FORMAT            to pik_public;
grant delete on NEW_GENERAL_KEY       to pik_public;
grant delete on NEW_HOR_COORD_SYS     to pik_public;
grant delete on NEW_INSTITUTE         to pik_public;
grant delete on NEW_LOCATION          to pik_public;
grant delete on NEW_MODEL             to pik_public;
grant delete on NEW_MODEL_TYPE        to pik_public;
grant delete on NEW_PERSON            to pik_public;
grant delete on NEW_PRESENTATION      to pik_public;
grant delete on NEW_PROGRESS          to pik_public;
grant delete on NEW_PROJECT           to pik_public;
grant delete on NEW_REF_TYPE          to pik_public;
grant delete on NEW_SPATIAL_DATA_ORG  to pik_public;
grant delete on NEW_STORAGE           to pik_public;
grant delete on NEW_TOPIC             to pik_public;
grant delete on NEW_UNIT              to pik_public;
grant delete on NEW_USE_CONSTRAINT    to pik_public;
grant delete on NEW_VER_COORD_SYS     to pik_public;
--
grant update on NEW_ACCESS_CONSTRAINT to pik_public;
grant update on NEW_ACCESS_STRUCTURE to pik_public;
grant update on NEW_ACCESS_TYPE to pik_public;
grant update on NEW_AGGREGATION to pik_public;
grant update on NEW_CITATION to pik_public;
grant update on NEW_CITATION_TYPE to pik_public;
grant update on NEW_CONNECT_TYPE to pik_public;
grant update on NEW_CONTACT_TYPE to pik_public;
grant update on NEW_CURRENTNESS_REF to pik_public;
grant update on NEW_ENTRY_TYPE to pik_public;
grant update on NEW_FEES to pik_public;
grant update on NEW_FORMAT to pik_public;
grant update on NEW_GENERAL_KEY to pik_public;
grant update on NEW_HOR_COORD_SYS to pik_public;
grant update on NEW_INSTITUTE to pik_public;
grant update on NEW_LOCATION to pik_public;
grant update on NEW_MODEL             to pik_public;
grant update on NEW_MODEL_TYPE        to pik_public;
grant update on NEW_PERSON to pik_public;
grant update on NEW_PRESENTATION to pik_public;
grant update on NEW_PROGRESS to pik_public;
grant update on NEW_PROJECT to pik_public;
grant update on NEW_REF_TYPE to pik_public;
grant update on NEW_SPATIAL_DATA_ORG to pik_public;
grant update on NEW_STORAGE to pik_public;
grant update on NEW_TOPIC to pik_public;
grant update on NEW_UNIT to pik_public;
grant update on NEW_USE_CONSTRAINT to pik_public;
grant update on NEW_VER_COORD_SYS to pik_public;
--
--
--
grant select on SEQ_ACCESS_CONSTRAINT to pik_public;
grant select on SEQ_ACCESS_TYPE       to pik_public;
grant select on SEQ_AGGREGATION       to pik_public;
grant select on SEQ_CITATION          to pik_public;
grant select on SEQ_CITATION_TYPE     to pik_public;
grant select on SEQ_CONNECT_TYPE      to pik_public;
grant select on SEQ_CONTACT_TYPE      to pik_public;
grant select on SEQ_CURRENTNESS_REF   to pik_public;
grant select on SEQ_ENTRY             to pik_public;
grant select on SEQ_ENTRY_TYPE        to pik_public;
grant select on SEQ_FEES              to pik_public;
grant select on SEQ_FORMAT            to pik_public;
grant select on SEQ_GENERAL_KEY       to pik_public;
grant select on SEQ_HOR_COORD_SYS     to pik_public;
grant select on SEQ_INSTITUTE         to pik_public;
grant select on SEQ_LOCATION          to pik_public;
grant select on SEQ_PERSON            to pik_public;
grant select on SEQ_PRESENTATION      to pik_public;
grant select on SEQ_PROGRESS          to pik_public;
grant select on SEQ_PROJECT           to pik_public;
grant select on SEQ_QUALITY           to pik_public;
grant select on SEQ_REF_TYPE          to pik_public;
grant select on SEQ_SPATIAL_COVERAGE  to pik_public;
grant select on SEQ_SPATIAL_DATA_ORG  to pik_public;
grant select on SEQ_SUMMARY           to pik_public;
grant select on SEQ_TEMPORAL_COVERAGE to pik_public;
grant select on SEQ_TOPIC             to pik_public;
grant select on SEQ_UNIT              to pik_public;
grant select on SEQ_USE_CONSTRAINT    to pik_public;
grant select on SEQ_VER_COORD_SYS     to pik_public;
--
grant select on SEQ_DATA_ACCESS       to pik_public;
grant select on SEQ_ACCESS_STRUCTURE  to pik_public;
grant select on SEQ_STORAGE           to pik_public;
--
grant select on SEQ_MODEL             to pik_public;
grant select on SEQ_MODEL_TYPE        to pik_public;
--
grant select on SEQ_REC_STRUCTURE     to pik_public;
--
grant select on SEQ_DATA_ORG          to pik_public;
grant select on SEQ_DIM_TYPE          to pik_public;
grant select on SEQ_MOMENT            to pik_public;
grant select on SEQ_POINT             to pik_public;
grant select on SEQ_POINT_SET         to pik_public;
grant select on SEQ_POSITION          to pik_public;
grant select on SEQ_SCALE             to pik_public;
grant select on SEQ_SPACE             to pik_public;
grant select on SEQ_TIME              to pik_public;
