Publication.RevokePublicationAccess(String) Method

Definition

Namespace:

Microsoft.SqlServer.Replication

Assembly:

Microsoft.SqlServer.Rmo.dll

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