Propriété Publication.SnapshotGenerationAgentPublisherSecurity

Gets the security context used by the Snapshot Agent to connect to the Publisher.

Espace de noms :  Microsoft.SqlServer.Replication
Assembly :  Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)

Syntaxe

'Déclaration
Public ReadOnly Property SnapshotGenerationAgentPublisherSecurity As IConnectionSecurityContext 
    Get
'Utilisation
Dim instance As Publication 
Dim value As IConnectionSecurityContext 

value = instance.SnapshotGenerationAgentPublisherSecurity

public IConnectionSecurityContext SnapshotGenerationAgentPublisherSecurity { get; }

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

member SnapshotGenerationAgentPublisherSecurity : IConnectionSecurityContext

function get SnapshotGenerationAgentPublisherSecurity () : IConnectionSecurityContext

Valeur de propriété

Type : Microsoft.SqlServer.Replication.IConnectionSecurityContext
An IConnectionSecurityContext object that represents the security context used by the Snapshot Agent to connect to the Publisher.

Notes

Call Update after changing the properties on the returned IConnectionSecurityContext object.

The SnapshotGenerationAgentPublisherSecurity property can only be retrieved by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

Properties of the returned IConnectionSecurityContext object can only be set by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

Retrieving the SnapshotGenerationAgentProcessSecurity property is equivalent to executing sp_helppublication_snapshot (Transact-SQL).

Setting properties of the returned IConnectionSecurityContext object is equivalent to executing sp_addpublication_snapshot (Transact-SQL) or sp_changepublication_snapshot (Transact-SQL).

Remarque relative à la sécurité
When possible, prompt users to enter security credentials at run time. If you must store credentials, use the cryptographic services provided by the Windows .NET Framework.

Voir aussi

Référence

Publication Classe

Espace de noms Microsoft.SqlServer.Replication