• Article

Publication.RevokePublicationAccess Method

Removes the specified login from the publication access list (PAL).

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

Syntax

'Declaration
Public Sub RevokePublicationAccess ( _
    loginName As String _
)
'Usage
Dim instance As Publication
Dim loginName As String

instance.RevokePublicationAccess(loginName)

public void RevokePublicationAccess(
    string loginName
)

public:
void RevokePublicationAccess(
    String^ loginName
)

member RevokePublicationAccess : 
        loginName:string -> unit 

public function RevokePublicationAccess(
    loginName : String
)

Parameters

Exceptions

Exception Condition
ApplicationException

If the publication does not exist on the server.
ArgumentException

If the supplied String is null, too long, or invalid.

Remarks

Only members of the sysadmin fixed server role at the Publisher or the db_owner fixed database role on the publication database can call RevokePublicationAccess.

Calling RevokePublicationAccess is equivalent to executing sp_revoke_publication_access (Transact-SQL).

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