Share via

  • Article

ReplicationDatabase.LogReaderAgentPublisherSecurity Property

Gets the login used by the Log Reader Agent to connect to the Publisher.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public ReadOnly Property LogReaderAgentPublisherSecurity As IConnectionSecurityContext
    Get
'Usage
Dim instance As ReplicationDatabase
Dim value As IConnectionSecurityContext

value = instance.LogReaderAgentPublisherSecurity

public IConnectionSecurityContext LogReaderAgentPublisherSecurity { get; }

public:
property IConnectionSecurityContext^ LogReaderAgentPublisherSecurity {
    IConnectionSecurityContext^ get ();
}

member LogReaderAgentPublisherSecurity : IConnectionSecurityContext

function get LogReaderAgentPublisherSecurity () : IConnectionSecurityContext

Property Value

Type: Microsoft.SqlServer.Replication.IConnectionSecurityContext
An IProcessSecurityContext value that specifies the type of authentication and login used by the Log Reader Agent to connect to the Publisher.

Remarks

For security reasons, Password is always masked in the return value.

The LogReaderAgentPublisherSecurity property can be retrieved by members of the sysadmin fixed server role or by members of the db_owner fixed database role of the published database.

Retrieving the LogReaderAgentPublisherSecurity property is equivalent to executing sp_helplogreader_agent (Transact-SQL).

The LogReaderAgentPublisherSecurity property is available with SQL Server 2005 only.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.