This topic has not yet been rated - Rate this topic

Publication.RevokePublicationAccess Method

SQL Server 2012

Other Versions

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

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

Syntax

C++

JScript

public void RevokePublicationAccess(
	string loginName
)

Parameters

loginName: Type: System.String
A String value that specifies the login of a user in the PAL.

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

Reference

Publication Class

Microsoft.SqlServer.Replication Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD