USE master
CREATE LOGIN <pcrs_readonly> WITH PASSWORD=<'pcrs_readonly'>, DEFAULT_DATABASE=<repository database name>, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
USE <<repository database name>>
CREATE USER <pcrs_readonly> FOR LOGIN 'pcrs_readonly'
ALTER USER pcrs_readonly WITH DEFAULT_SCHEMA=db_datareader
EXEC sp_addrolemember N'db_datareader', N'pcrs_readonly'
EXEC sp_addrolemember N'db_ddladmin', N'pcrs_readonly'
GRANT CREATE TABLE TO pcrs_readonly
GRANT DELETE,INSERT TO pcrs_readonly
GRANT SELECT ON sys.database_files TO pcrs_readonly