Project and Portfolio Management Practitioners Forum
cancel

SQL non-functional in PPM database

SOLVED
Go to solution
Highlighted
sam.greg
Honored Contributor.

SQL non-functional in PPM database

Hi,

In PPM database, I could see many columns for a table - req no, date, manager, parameter1, visibleparameter1, p2,vp2...p40,vp40.

But, when I try to use SQL statement to view this table - "select * from tabel" it shows only - ren no, date, manager. It does not show p1,vp1,p2,vp2...etc

Any idea why it is like that?


Thanks in advance

Regards,
Sam.
2 REPLIES
Niraj Prabhu
Outstanding Contributor.
Solution

Re: SQL non-functional in PPM database

Sam,

This is more over a Database issue, Try contacting Database Administrators to figure out if the Table definition or any access grants is stopping for this.

Thanks!
Niraj
Niraj P.
sam.greg
Honored Contributor.

Re: SQL non-functional in PPM database

Thanks Niraj. It was an issue with my privileges.