It’s a good news that SQL Server 2005 comes with a fixed database role replmonitor to allow non-admin staff (developers etc) to view the Replication Monitor.
To set it up:
1. CREATE USER username in the distribution database
2. Assign replmonitor database role to the username
Your developers etc should be able to check out the status of replication [...]
Posts Tagged ‘permission’
Replication Monitor For Non-Admin
Posted in SQL Server, tagged permission, security on 11 May 2009 | Leave a Comment »
Categories
- General (3)
- Programming (1)
- SCOM (2)
- SQL Server (24)
- Windows (4)
Past entries
- November 2009 (2)
- September 2009 (4)
- August 2009 (3)
- July 2009 (4)
- June 2009 (7)
- May 2009 (13)
What I Blogged
administration adventureworks alerts ASP desktop diagnostic display error installation login mobile phone modify one-liner overrides performance permission random stuffs remote desktop replication restore rules schema scripts security surviving accidents suspect database task manager tips trigger troubleshooting tsql Windows group Windows XP workaroundPages
-
Top Posts
