Publication.RevokePublicationAccess(String) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Replication

Assembly:: Microsoft.SqlServer.Rmo.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 void RevokePublicationAccess(System::String ^ loginName);

public void RevokePublicationAccess (string loginName);

member this.RevokePublicationAccess : string -> unit

Public Sub RevokePublicationAccess (loginName As String)

Parameters

loginName: String

A String value that specifies the login of a user in the PAL.

Exceptions

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).

Applies to