I got below error message while running “Test_SPProjectDatabase” command on Project Server 2013 Database during upgrade process.
=============================================
Category : Security
Error : True
UpgradeBlocking : False
Message : The following roles are missing from the database: 'PSDataAccess', 'PSReportingSchemaAdmin'
===============================================
Apparently the above roles were not present in the Project Server Database. I resolved the issue by creating these roles manually and by granting them appropriate permissions.
Below is the sql script to create the roles.
================================================
CREATE ROLE [PSDataAccess] AUTHORIZATION [dbo]
GO
CREATE ROLE [PSReportingSchemaAdmin] AUTHORIZATION [dbo]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [dbo] TO [PSDataAccess]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [draft] TO [PSDataAccess]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [pub] TO [PSDataAccess]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [ver] TO [PSDataAccess]
GO
GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [dbo] TO [PSReportingSchemaAdmin]
GO
GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [draft] TO [PSReportingSchemaAdmin]
GO
GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [pub] TO [PSReportingSchemaAdmin]
GO
GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [ver] TO [PSReportingSchemaAdmin]
GO
======================================================
