terça-feira, 8 de novembro de 2011 06:13
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
Todas as Respostas
domingo, 11 de março de 2012 18:29
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?
- Sugerido como Resposta Manish M Upadhyay terça-feira, 24 de julho de 2012 12:28
segunda-feira, 12 de março de 2012 10:58
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.
segunda-feira, 12 de março de 2012 16:13Indeed... 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...
domingo, 29 de julho de 2012 12:02
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!