Rem
Rem $Header: cwm2mrgp.sql 04-jun-2007.08:12:36 glyon Exp $
Rem
Rem cwm2mrgp.sql
Rem
Rem Copyright (c) 2002, 2004, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2mrgp.sql - grant script for new performance metadata reader packages 
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       06/04/07 - replace public with cwm_user in grant execute
Rem    cdalessi    01/23/04 - cdalessi_txn110297 
Rem    dbardwel    01/21/04 - Created
Rem

Rem package cwm2_olap_mr_security_init has only one procedure:
Rem init_mr_session_object_table.  It is called from C code during the
Rem initialization of OLAP API sessions, so users who don't hold CWM_USER
Rem need to be able to execute it.  The procedure accepts no arguments, so
Rem it is not susceptible to first-order SQL injection attacks.
grant execute on olapsys.cwm2_olap_mr_security_init to public
/

grant execute on olapsys.cwm2_olap_mr_session_pop to CWM_USER
/

grant execute on olapsys.cwm2_olap_mr_check_privs to CWM_USER
/

grant execute on olapsys.cwm2_olap_metadata_refresh to CWM_USER
/