How to grant select on PXRPTUSER views to non Primavera P6 user

Home/P6/How to grant select on PXRPTUSER views to non Primavera P6 user

How to grant select on PXRPTUSER views to non-primavera p6 user 

Sometimes, Other database schemas require select access to PXRPTUSER views. For example, a data warehouse (EDW) schema  might require access to PXRPTUSER views to produce an analytical report OR a custom database schema may require select all view access. The PXRPTUSER views are referring to ADMUSER tables so the only grant VIEW access will not work here.  

Follow below the steps for how to grant select on  PXRPTUSER VIEW access to another schema: 

 

  1.  Login as ADMUSER and run the below query. It grants SELECT table access with grant option to PXRPTUSER 

 

 

2. Also, run the below queries from ADMUSER. Replace USER_NAME with your user account 

 

 

3. Also modify the ADMUSER.SECPAC package to include your Oracle username as shown in RED circle and compile it .  

 

SECPAC How to grant select on PXRPTUSER views to non Primavera P6 user

 

4. Finally, Login as PXRPTUSER and run the below query. Replace USER_NAME with your oracle user account.  It grant all the PXRPTUSER views to your Oracle user account  🙂 

 

 

 

 

govindan How to grant select on PXRPTUSER views to non Primavera P6 user
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan How to grant select on PXRPTUSER views to non Primavera P6 user
Connect me
By | 2017-06-26T18:33:20+00:00 May 18th, 2017|Categories: P6|Tags: |0 Comments
Like us on Facebook.
Connect!