RE: Permission to start/stop logreader and distribution agent

From: Armin (anonymous_at_discussions.microsoft.com)
Date: 01/28/04


Date: Wed, 28 Jan 2004 06:23:07 -0800

Thank you very much for your answer, Kevin!

But I have a problem - there is no replmonitor role in
distribution database, at least I can not see it. Maybe
this role exists in SQL2K, not in SQL 7.0?

Best regards,

Armin
>-----Original Message-----
>>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.
>
>
>
>.
>



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: Permission to start/stop logreader and distribution agent
    ... 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)