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