DistributionDatabase.QueueReaderAgentProcessSecurity Property

Artikkeli
12/03/2008

Gets the agent process security context for running the Queue Reader Agent job.

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

Syntax

'Declaration
Public ReadOnly Property QueueReaderAgentProcessSecurity As IProcessSecurityContext

public IProcessSecurityContext QueueReaderAgentProcessSecurity { get; }

public:
property IProcessSecurityContext^ QueueReaderAgentProcessSecurity {
    IProcessSecurityContext^ get ();
}

/** @property */
public IProcessSecurityContext get_QueueReaderAgentProcessSecurity ()

public function get QueueReaderAgentProcessSecurity () : IProcessSecurityContext

Property Value

An instance of the IProcessSecurityContext interface.

Remarks

QueueReaderAgentProcessSecurity is a read-only property. Use the returned IProcessSecurityContext interface to specify the Microsoft Windows account under which the Queue Reader Agent job runs. For information about the connections that agents make and the permissions that are required for those connections, see Replication Agent Security Model.

The QueueReaderAgentProcessSecurity property can only be retrieved by members of the sysadmin fixed server role at the Distributor or by members of the db_owner fixed database role on the distribution database.

The properties of the returned IProcessSecurityContext object can only be set by members of the sysadmin fixed server role at the Distributor.

Retrieving the QueueReaderAgentProcessSecurity property is equivalent to executing sp_helpqreader_agent.

Setting the properties of the returned IProcessSecurityContext interface is equivalent to executing sp_addqreader_agent or sp_changeqreader_agent.

The QueueReaderAgentProcessSecurity property is available with SQL Server 2005 only.

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms