none
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:
    http://msdn.microsoft.com/en-us/library/office/ee767707(v=office.14).aspx

    Security Web service:
    http://msdn.microsoft.com/en-us/library/office/websvcsecurity_di_pj14mref(v=office.14).aspx

    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.
    http://gallery.technet.microsoft.com/projectserver/Server-2010-Powershell-b9237c0e

    HTH.


    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: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, December 19, 2012 5:13 AM