Informatica Proactive Monitoring
- Informatica Proactive Monitoring 3.0 HotFix 1
- All Products
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