User's security category list RRS feed

  • Question

  • Hi,

    Can anyone provide me the SQL query to get a user security category list in project server 2010.

    Thank you.

    Wednesday, December 19, 2012 3:26 AM

All replies

  • Hi Bala,

    The securtity related data is not stored in project server reporting database. You may need to use the PSI -security web service to get the related data.

    Overview of PSI services:

    Security Web service:

    Though we know that Published database contains the security related data in MSP_WEB_SECURITY_CATEGORIES table  but should only be accessed using the PSI. Direct query of published/draft database is NOT supported.

    You may also try with Powershell: Here is a sample but this also uses PSI calls.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog:

    Wednesday, December 19, 2012 5:13 AM