Question:  Good afternoon I need to make a query on the database projectserver 2007. This query should return if a user has access to a project Thanks in advance

 

Answer:  We recommend leveraging the EPM Report Pack update for Project Server 2007.  More specifically, there is a sample report in there Security Permission on User Level.  These report shows permissions for each user and can be easily modified to show all users with a specific permission. 

A link to the report pack can be found here:  http://archive.msdn.microsoft.com/EPMReportPack/Release/ProjectReleases.aspx?ReleaseId=3114

 

-Dan