Configuring the GVP Reporting Server Database

The GVP 8.5 Reporting Server requires one of two supported relational database systems is installed Microsoft SQL Server or Oracle. The database and the Reporting Server can share a host or you can install the database on a separate host. This section describes how to create the GVP Reporting database schema and partitioning the database in the following topics:

• Before You Begin
• Setting Up the Database
• Partitioning CDR and Event Log Tables
• Recovery Model for Microsoft SQL Server
• Preventing Clickjacking

Before You Begin

• Genesys recommends that the VP Reporting Server is installed before you or your database administrator create a database in your Database Management System (DBMS).
• Ensure that a fully functional instance of the Microsoft SQL Server or Oracle exists in your deployment.
• Create the Reporting Server database.
  Important

  This section describes the creation of the database schema only. The setup of the Microsoft SQL Server or Oracle 10g instances is outside the scope of this document. For information about setting up these instances, see the vendor documentation.
• For installations using an Oracle database, the database administrator should grant the following system privileges to the user(s) who will own the Reporting Server schema:
  • CREATE TRIGGER
  • CREATE SEQUENCE
  • CREATE TABLE
  • CREATE PROCEDURE
  • FORCE TRANSACTION
  • CREATE VIEW
  • CREATE SESSION
  • UNLIMITED TABLESPACE

  Setting Up the Database

  This section includes a description of a generic procedure to create the database schemas.

  Important

  Genesys recommends that the user setting up an Oracle database be a different user than the one used to create the Configuration Server database.

  
  The table below contains the paths to the scripts that are used to create the database schema. Select the path to the script that matches the edition (standard or enterprise) of the database that you selected during installation of the Reporting Server component.
  
  

  A minor change is required when Reporting Server is deployed with an Oracle RAC database. When the hibernate.remote.database configuration option is used, the Reporting Server internally appends some parameters to the value of the hibernate.remote.url option, including the value of the hibernate.remote.database option. Therefore, ensure the hibernate.remote.url option is properly configured for use with Oracle RAC by configuring the hibernate.remote.database option with the value blank.

  Table 30: Database Script Files

  Script file	Default path
  mssql_schema.sql	For Windows: <Installation_Directory>\scripts\standard <Installation_Directory>\scripts\enterprise
  oracle_schema.sql	For Windows: <Installation_Directory>\scripts\standard <Installation_Directory>\scripts\enterprise
  mssql_schema.sql	For Linux: <Installation_Directory>/scripts/standard <Installation_Directory>/scripts/enterprise
  oracle_schema.sql	For Linux: <Installation_Directory>/scripts/standard <Installation_Directory>/scripts/enterprise

  Important

  The Reporting Server supports the partitioning option for Oracle 10g or 11g enterprise version, and SQL Server 2008 enterprise versions. For all other databases, including SQL Server 2005 (enterprise or standard), use the \scripts\standard\ path to find the appropriate scripts.

  Reporting Server in Partition Mode on Oracle

  When the Reporting Server is installed in partitioned mode (Enterprise) on Oracle by and the default GATHER_STATS_JOB option is used to automatically gather statistics, server performance can be severely affected. In partitioned mode, the Reporting Server database uses rotating staging tables that are flushed throughout the day. These volatile tables are not suited for automatic statistics gathering.

  Genesys recommends the following:

  • Disable the GATHER_STATS_JOB option before you install the Reporting Server database to ensure that inaccurate statistics are not associated with the staging tables.
  • Use the provided lock-stats script to lock the staging tables, for example: <RS_INSTALLATION_DIRECTORY>/scripts/enterprise/ReportingService/sql/oracle-lock-stats.sql
    This script uses the following Oracle SQL procedure:
    DBMS_STATS.LOCK_TABLE_STATS (
    ownname VARCHAR2,
    tabname VARCHAR2);
    …where the ownname option must be the name of the schema that is associated with the Reporting Server tables. The script assumes the schema name is REPORTING. You must replace all instances of REPORTING with the proper schema name.

  Procedure: Setting Up a Database for the Reporting Server

  There are many available query tools that SQL Server and Oracle 10 g can use to execute Structured Query Language (SQL) scripts. For example, SQL Server Management Studio is included in Microsoft SQL Enterprise edition, and Oracle SQL Developer is available on the Oracle website.

  Oracle is the only supported database when the Reporting Server DBMS is installed on Linux operating systems.

  Microsoft cumulative update packages for SQL Server contain the most recent hot fixes and security fixes. Ensure that the hot fix that is listed as a prerequisite for this procedure is included in the Service Pack that you have installed.

  1. Verify that:
     • Microsoft SQL hot-fix build 3175 must be installed.
     • The Microsoft SQL Server Management Studio development tool is installed on the SQL Server.
     • Sun Java Runtime Environment, is installed.
  2. On the SQL server, select the Reporting Server database (MSSQL or Oracle) and run the appropriate script. See Table: Database Script Files for a list of DBMSs and the corresponding name and location of the initialization script files.
  3. Open the folder that matches your database type.
  4. Load and execute the initialization script that corresponds to your DBMS. For information about how to upgrade the database schemas, see Migrating to GVP 8.5.

  Partitioning CDR and Event Log Tables

  GVP 8.1.2 and later releases support partitioned CDR and Event Log tables in the Reporting Database. The Resource Manager, Media Control Platform, Call Control Platform, VAR CDR tables, and Event Logs table tend to grow rapidly in large-scale environments. To improve the read/write performance, these database tables can be split into multiple partitions, each of which represents a specific period of time. Partitioning is supported only in the Enterprise editions of Oracle and Microsoft SQL databases.

  The Reporting Database can be configured for partitioning in the following ways:

  • During the installation of Reporting Server 8.1.2, if the user selects the Enterprise edition of either product, the rs.partitioning.enabled configuration option in the persistence section is automatically set to true.
  • The rs.partitioning.partitions-per-day option in the persistence section is used to change the number of partitions per day. The default value is 6, however, the value can be increased in environments that experience high call volumes.
    Tip

    When database partitioning is enabled, Genesys recommends that you not change the partitioning mode of operation or the number of partitions (even after the Reporting Server is started), because of issues that might arise if the database schema or stored data is changed.
  • The Reporting Database 8.1.2 schemas are different for enterprise and standard editions and are located in different directories. To create the schema that is compatible with your database selection, see Procedure: Setting Up a Database for the Reporting Server. For more a complete list of configuration options for database partitioning, see the GVP 8.5 User's Guide.

    Recovery Model for Microsoft SQL Server

    If you are installing your database on Microsoft SQL Server, Genesys recommends that you use the SQL Server Simple Recovery Model, which is a simple backup that can be used to replace your entire database in the event of a failure or to restore your database to another server. This mode enables you to do a complete backup (all of the data) or a differential backup (data that has changed since the last complete backup only).

    This model is a basic recovery model. Every transaction is written to the transaction log, however, the space is reused by new transactions when previous transactions are complete and written to the data file. Since this space is reused, you cannot do a point-in-time recovery. The most recent restore point becomes either the complete backup or the latest differential backup. However, because the transaction log space is reused, the log does get continuously larger, as it does in the Full Recovery Model.

    For more information about the types of data this recovery mode is used for and a complete list of backups you can use, see the MSSQL Tips web site.

    Tip

    If you choose not to use this recovery mode, Genesys recommends that you backup your transaction logs regularly.

    Use one of these two methods to configure the Simple Recovery Model...

    METHOD 1

    Use T-SQL to enter the following command line:
    ALTER DATABASE <dbName> SET RECOVERY recoveryOption GO
    where <dbName> is the name of the database.

    METHOD 2

    Use SQL Server Management Studio:

    1. Right-click on database name and select Properties.
    2. Select the Options page.
    3. Click the Recovery model: drop-down menu and select Simple.
    4. Click OK to save the configuration.

    Procedure: Specify a Non-schema-owner Oracle User on Reporting Server (Running Oracle Partition Mode)

    Enable Reporting Server to run in Oracle partition mode, using an application user other than the schema owner. (Please edit and change "password", usernames and table space names if needed.)

    Oracle documentation offers a reason for this procedure: System privileges can be very powerful, and should be granted only when necessary to roles and trusted users of the database. It is better to define application users and grant those users the necessary privileges on the schema owners objects.

    1. Install your Oracle database.
    2. Create Users, role and current schema trigger.
       Note that the schema user's system privileges must be granted directly; not through a role.
    3. Run the script in the following link in a connection as SYSDBA:
       [+] Copy the script from this link

       -- USER SQL
       CREATE USER RS_SCHEMA_OWNER IDENTIFIED BY password
       
       DEFAULT TABLESPACE "USERS"
       TEMPORARY TABLESPACE "TEMP";
       -- ROLES
       -- SYSTEM PRIVILEGES
       GRANT FORCE TRANSACTION TO RS_SCHEMA_OWNER ;
       GRANT CREATE TRIGGER TO RS_SCHEMA_OWNER ;
       GRANT CREATE SEQUENCE TO RS_SCHEMA_OWNER ;
       GRANT CREATE TABLE TO RS_SCHEMA_OWNER ;
       GRANT CREATE VIEW TO RS_SCHEMA_OWNER ;
       GRANT CREATE SESSION TO RS_SCHEMA_OWNER ;
       GRANT UNLIMITED TABLESPACE TO RS_SCHEMA_OWNER ;
       GRANT CREATE PROCEDURE TO RS_SCHEMA_OWNER ;
       /
       
       -- USER SQL
       CREATE USER GEN_REPORTING_APP_RS IDENTIFIED BY password
       DEFAULT TABLESPACE "USERS"
       TEMPORARY TABLESPACE "TEMP";
       -- ROLES
       -- SYSTEM PRIVILEGES
       GRANT CREATE SESSION TO GEN_REPORTING_APP_RS ;
       GRANT UNLIMITED TABLESPACE TO GEN_REPORTING_APP_RS ;
       /
       CREATE ROLE GEN_REPORTING_RW_ROLE
       /
       GRANT GEN_REPORTING_RW_ROLE TO GEN_REPORTING_APP_RS
       /
       CREATE OR REPLACE TRIGGER GEN_REPORTING_APP_RS.AFTER_LOGON_TRIGGER
       AFTER LOGON ON GEN_REPORTING_APP_RS.SCHEMA
       BEGIN
       EXECUTE IMMEDIATE 'ALTER SESSION SET current_schema=RS_SCHEMA_OWNER';
       END;
       /

    4. Run the Reporting Server script in
       RS_INSTALL_ROOT/scripts/enterprise/oracle-schema.sql
       using the schema owner's connection.
    5. Run the script in the following link, using the schema owner's connection:
       [+] Copy the script from this link

       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CUSTOM_VARS_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CUSTOM_VARS_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CUSTOM_VARS_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CUSTOM_VARS_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON DATECOMPONENTS TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON EVENT_LOGS_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON EVENT_LOGS_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON EVENT_LOGS_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON EVENT_LOGS_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LAST_ARRIVAL_COUNTED_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LAST_PARTITIONED TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LAST_PARTITIONED_ERROR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LAST_PROCESSED_JMS_MESSAGE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LATENCIES TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LATENCY_CONFIGURATIONS TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LASTCUTOFFRECORD TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON LASTSUMMARIZED TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_TREAT_NV_COUNTS_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_TREAT_NV_COUNTS_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_TREAT_NV_COUNTS_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_TREAT_NV_COUNTS_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_COUNTS_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_COUNTS_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_COUNTS_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_COUNTS_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_COUNTED_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_IVR_ACTION_STATS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_IVR_ACTION_STATS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_IVR_ACTION_STATS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_IVR_ACTION_STATS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_IVR_ACTION_STATS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_IVR_ACTION_STATS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_RESULT_STATS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_RESULT_STATS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_RESULT_STATS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_RESULT_STATS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_RESULT_STATS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PERIOD_RESULT_STATS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TIMECOMPONENTS TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_STAGE_1_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_STAGE_1_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_STAGE_2_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_STAGE_3_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_FUTURE_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_HIST_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON PSTNC_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_STAGE_1_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_STAGE_2_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_STAGE_3_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_FUTURE_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_HIST_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_DURATIONS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_DURATIONS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_DURATIONS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_DURATIONS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_DURATIONS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_DURATIONS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON ASR_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CUSTOM_VARS_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON EVENT_LOGS_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_EXT_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_EXT_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_EXT_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_EXT_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_EXT_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_TREAT_NV_COUNTS_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_EXT_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_EXT_HIST TO GEN_REPORTING_RW_ROLE;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_EXT_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_EXT_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_EXT_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CTIC_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_COUNTS_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_DURATIONS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_DURATIONS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_DURATIONS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_DURATIONS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_DURATIONS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_DURATIONS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_DURATIONS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_DURATIONS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_DURATIONS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_DURATIONS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON SQFAILURE_DETAILS TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON SQ_SUMMARY_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON SQ_SUMMARY_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON SQ_SUMMARY_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON SQ_SUMMARY_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_DURATIONS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_DURATIONS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_DURATIONS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_DURATIONS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_DURATIONS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_DURATIONS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON TTS_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_EXT_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_EXT_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_EXT_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_EXT_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_CDR_EXT_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_STAGE_2_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_STAGE_3_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_FUTURE_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_HIST_TABLE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_DURATIONS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_DURATIONS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_PEAKS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_PEAKS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_PEAKS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_PEAKS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_PEAKS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RMDN_PEAKS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_ARRIVALS_30MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_ARRIVALS_5MIN TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_ARRIVALS_DAY TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_ARRIVALS_HOUR TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_ARRIVALS_MONTH TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON RM_ARRIVALS_WEEK TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON VAR_CDRS_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON VAR_CDRS_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON VAR_CDRS_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON VAR_CDRS_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT,INSERT,UPDATE,DELETE ON VAR_CDRS_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON ASR_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON ASR_DURATIONS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON ASR_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_CDR TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_EXT TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_CDR_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CCP_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CTIC_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CTIC_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON CUSTOM_VARS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON EVENT_LOGS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_CDR TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_EXT TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_CDR_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_TREAT_NV_COUNTS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_COUNTS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_DURATIONS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MCP_VXML_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_DURATIONS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON MEDIA_SERVICE_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON PERIOD_IVR_ACTION_STATS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON PERIOD_RESULT_STATS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON PSTNC_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON PSTNC_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RMDN_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RMDN_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_CDR TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_CDR_EXT TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_CDR_FUTURE TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_CDR_HIST TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_CDR_STAGE_1 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_CDR_STAGE_2 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_CDR_STAGE_3 TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON RM_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON SQ_SUMMARY TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON TTS_ARRIVALS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON TTS_DURATIONS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON TTS_PEAKS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT,INSERT,UPDATE,DELETE ON VAR_CDRS TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT ON TABLE_PARTITION TO GEN_REPORTING_RW_ROLE ;
       GRANT SELECT ON TABLE_SUBPARTITION TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON CCP_CDR_EXT_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON CCP_CDR_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON CUSTOM_VARS_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON GENERIC_LOG_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON HIBERNATE_SEQUENCE TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON MCP_CDR_EXT_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON MCP_CDR_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON RM_CDR_EXT_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON RM_CDR_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON TREAT_COUNTS_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON VAR_CDR_EXT_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT ALTER,SELECT ON VXML_COUNTS_SEQ TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CUSTOMVARDTO_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON VARCALLDETAILRECORD_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CUSTOMVARDTO_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON VARCALLDETAILRECORD_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON GENERICLOG_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON GENERICLOG_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CCPCALLDETAILRECORDEXT_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CCPCALLDETAILRECORD_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CCPCALLDETAILRECORDEXT_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CCPCALLDETAILRECORD_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON MCPCALLDETAILRECORDEXT_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON MCPCALLDETAILRECORD_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON MCPCALLDETAILRECORDEXT_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON MCPCALLDETAILRECORD_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON RMCALLDETAILRECORDEXT_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON RMCALLDETAILRECORD_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON RMCALLDETAILRECORDEXT_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON RMCALLDETAILRECORD_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CDR_EXT_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CDRTREATMENTNOVXMLCOUNT_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CDRTREATMENTNOVXMLCOUNT_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CDRVXMLSECONDCOUNT_PDROP TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON REBUILD_TABLE_SUBPARTITION TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON CDRVXMLSECONDCOUNT_PARCH TO GEN_REPORTING_RW_ROLE ;
       GRANT EXECUTE ON REBUILD_TABLE_INDEXES TO GEN_REPORTING_RW_ROLE ;

    Preventing Clickjacking

    Reporting Server supports reading configuration from [reporting] response.header, [reporting] response.header.landingpage and adds the value in HTTP response header from 8.5.181.77. To prevent chances of a Clickjacking attack, the value can be configured as "X-Frame-Options: DENY". This will add X-Frame-Options: DENY header in HTTP responses to all RS Web APIs requests (http://<rs_host>:<port>://ems-rs/xxxxx). This option is hidden by default and must added explicitly in the reporting section.

    You must update the response.header and response.header.landingpage parameter values with the required security response headers separated by " | ". To do this, follow these steps:

    1. Go to Reporting Server Application properties > Options > [reporting].
    2. In [reporting], update the response.header and response.header.landingpage parameter values with the required security response headers separated by " | ":
       • response.header.landingpage=X-Frame-Options: DENY|X-XSS-Protection: 1; mode=block|X-Content-Type-Options: nosniff|Content-Security-Policy: script-src http://<rs_host>:<port>/
         
       • response.header=X-Frame-Options: DENY|X-XSS-Protection: 1; mode=block|X-Content-Type-Options: nosniff|Content-Security-Policy: script-src http://<rs_host>:<port>/ems-rs/

    You must update the http URL given in the Content-Security-Policy parameter with the actual RS IP Address and port. For example:
    From: http://<rs_host>:<port>/ems-rs/
    To: http://172.24.130.26:8090/ems-rs/
    

    User can add multiple security response headers in the response.header and response.header.landingpage parameter values separated by " | ".