Providing read only access to the Data Warehouse

Products

• Clarity PPM On Premise

Issue/Introduction

You need to provide  ODBC access,  so a user can have select access to data warehouse tables in order to develop reports in Power BI.

You need to create a Read Only user/role with SELECT privileges on the Data Warehouse

 

 

Environment

Release : 16.0.2

Component : Data Warehouse

Oracle

Resolution

Here is one way you may accomplish that.

In the example below, "datawarehouse_readonly_user" is your new user.

The data warehouse schema is "ppm_dwh".

CREATE USER datawarehouse_readonly_user IDENTIFIED BY abcd1234;

GRANT CREATE SESSION TO datawarehouse_readonly_user;

GRANT SELECT ON ppm_dwh TO datawarehouse_readonly_user;

When that user logs in, they will need to run this to 
be able to select against the Data Warehouse:

ALTER SESSION SET CURRENT_SCHEMA=ppm_dwh;