none
List of Project Permission in PS 2010 Using SQL query RRS feed

  • Question

  • Hi

    Is there any way to get a list of Project permissions associated with user using sql query. If i go manually Project center --> select project plan --> project permission it would take lot of time to find out for each user

    Regards

    Santosh

    Saturday, February 14, 2015 5:21 AM

All replies

  • Before you continue (which you probably will overlook) - please understand that you should only be querying the REPORTING database and not the published database.  A recommendation is to use a select statement statement to insert the tables into a table int the reporting database, then query that table for your results/report.  

    The following page I believe has what you're looking for (Users with direct permissions- query below) and more

    http://pmpspecialists.com/Blog/2013/10/

    SELECT     MSP_RESOURCES.RES_NAME AS Resourcename, CONV.CONV_STRING AS Permission, MSP_WEB_SECURITY_SP_CAT_PERMISSIONS.WSEC_DENY AS Denied,
                          MSP_WEB_SECURITY_SP_CAT_PERMISSIONS.WSEC_ALLOW AS Allowed
    FROM         MSP_WEB_SECURITY_SP_CAT_PERMISSIONS INNER JOIN
                          MSP_WEB_SECURITY_SP_CAT_RELATIONS ON
                          MSP_WEB_SECURITY_SP_CAT_PERMISSIONS.WSEC_REL_UID = MSP_WEB_SECURITY_SP_CAT_RELATIONS.WSEC_REL_UID INNER JOIN
                          MSP_WEB_SECURITY_FEATURES_ACTIONS ON
                          MSP_WEB_SECURITY_FEATURES_ACTIONS.WSEC_FEA_ACT_UID = MSP_WEB_SECURITY_SP_CAT_PERMISSIONS.WSEC_FEA_ACT_UID INNER JOIN
                          MSP_WEB_CONVERSIONS AS CONV ON CONV.CONV_VALUE = MSP_WEB_SECURITY_FEATURES_ACTIONS.WSEC_FEA_ACT_NAME_ID INNER JOIN
                          MSP_RESOURCES ON MSP_WEB_SECURITY_SP_CAT_RELATIONS.WSEC_SP_GUID = MSP_RESOURCES.RES_SECURITY_GUID
    WHERE     (CONV.LANG_ID = 1033)
    ORDER BY Resourcename, Permission

    Monday, February 16, 2015 5:17 PM
  • Hi,

    Same i am looking,how to get  information that how many user have permission on particular projects by SQL query.


    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

    Sunday, August 21, 2016 11:54 AM