RE: Permission to start/stop logreader and distribution agent

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 01/27/04

  • Next message: Agustin Chernitsky: "Help me stop the hacker..."
    Date: Tue, 27 Jan 2004 21:44:22 GMT
    
    

    >From BOL:

    users that are not members of the sysadmin fixed server role can monitor
    replication if they are defined with the replmonitor role in the
    distribution database. A system administrator can add any user to the
    replmonitor role, which allows that user to view replication activity with
    the Replication Monitor node in SQL Server Enterprise Manager; however, the
    user will not be able to administer replication.

    Thanks,

    Kevin McDonnell
    Microsoft Corporation

    This posting is provided AS IS with no warranties, and confers no rights.


  • Next message: Agustin Chernitsky: "Help me stop the hacker..."

    Relevant Pages

    • RE: Replication Monitor
      ... users that are not members of the sysadmin fixed server role can monitor ... replication if they are defined with the replmonitor role in the ... the Replication Monitor node in SQL Server Enterprise Manager; ...
      (microsoft.public.sqlserver.security)
    • RE: Replication Monitor
      ... >users that are not members of the sysadmin fixed server ... >replication if they are defined with the replmonitor role ... A system administrator can add any ... >the Replication Monitor node in SQL Server Enterprise ...
      (microsoft.public.sqlserver.security)
    • Re: Replication Failures - Distrib.exe Application Error
      ... replication monitor to monitor your replication to see if there is any ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
      (microsoft.public.sqlserver.replication)
    • Re: Transactional replication in SQL Server 2005
      ... Click on the tracer token tab. ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... I am using Replication Monitor for SQL 2005. ...
      (microsoft.public.sqlserver.replication)
    • Re: sql2005 merge subs suddenly expired--
      ... sub, & resubscribe... ... but in repl monitor those wierd entris remain, ... Looking for a SQL Server replication book? ... than your subscription retention setting. ...
      (microsoft.public.sqlserver.replication)