If you have ever run into a situation where you or someone changed the permissions of your only Administrator account in Project Server to something less permissive, then you will find the queries below helpful.
You would first need to run a query to find out the security group ID of your Administrators security group. Once this is done you would fun the first query below to get the information for the resources you would like to change. The query at the bottom inserts the appropriate record to create a relationship between your user account and Administrators security group.
SELECT MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID ,
MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID,
MSP_WEB_SECURITY_GROUP_MEMBERS.CREATED_DATE, MSP_WEB_SECURITY_GROUP_MEMBERS.MOD_DATE,
MSP_WEB_SECURITY_GROUP_MEMBERS.CREATED_REV_COUNTER,
MSP_WEB_SECURITY_GROUP_MEMBERS.MOD_REV_COUNTER,
MSP_RESOURCES.RES_NAME, MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME
FROM MSP_WEB_SECURITY_GROUP_MEMBERS INNER JOIN
MSP_RESOURCES ON
MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID = MSP_RESOURCES.RES_SECURITY_GUID INNER JOIN
MSP_WEB_SECURITY_GROUPS ON MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID = MSP_WEB_SECURITY_GROUPS.WSEC_GRP_GUID
WHERE (MSP_RESOURCES.RES_NAME LIKE '%sharepointprojadmin%') OR
(MSP_RESOURCES.RES_NAME = 'pwasysadmin') GO
----------------------------------------
INSERT INTO [Px_Prod_Published].[dbo].[MSP_WEB_SECURITY_GROUP_MEMBERS]
([WRES_GUID]
,[WSEC_GRP_GUID]
,[CREATED_DATE]
,[MOD_DATE]
,[CREATED_REV_COUNTER]
,[MOD_REV_COUNTER])
VALUES
('7895A25B-E099-4372-867B-447551F59346'
,'4E241D3E-5E0F-4AC5-B6F7-EAB14B3D43BA'
,GETDATE()
,GETDATE()
,0
,0)
GO
