How to query users who have been added under the 'Project Permisisons' button in PWA

Question

I have a request to provide a list of users per project who have been granted exclusive access to the project using the 'Project Permissions' button found in the Project Center. I looked into the Publishing Database schema but could not find the magic link. I know this is not the supported place to be querying but as its a one-off request, data which does not exist in the reporting DB and only a SQL read, it should have no risk to the application if I do it after hours.

Anyone out there have any potiners on how to get this data?

---

Regards, Piet Remen

Answer 1

Hi Piet,

I tried to find it for you, but no result.

A tried to trace the command, fired from PWA to the SQL Databases. It doesn't seem to be the good approach ;)

Wouldn't it be better to work with the PSI? If PWA can show you the security settings, you should be able to to it via the PSI too... Is this an option?

Regards
Wim

Answer 2

Hi Piet

          I may have a tedious kind of solution. Just click on 'Project Permissions' button on 'Project Center'. And the users or Groups with specified permissions can be found out there.

But sir you had to do it for each and every project one by one.

Regarde

Manish

Answer 3

Indeed... and I didn't find where it is stored in the DB. As such PSI remains as solution, but of course this is not the easyast way...

Answer 4

Just to follow this one up. The client never needed me to keep looking so I dropped the requirement in the end. However I would expect that data to exist in the Project Server Published database. I haven't gone looking for it but surely it would have to be there somewhere. No querying the data is not supported by Microsoft but you could get fancy and use some SQL magic to copy the published database each night to a secured location and then have your reports read data from the copied (shadowed) database. A scheduled SQL job should help you out with this job fairly quickly. If not in the published, try the draft... it's got to be there somewhere. Good luck!

---

Regards,

Piet Remen
http://pietremen.blogspot.com.au