Publication.RevokePublicationAccess Method

Article
12/03/2008

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

public void RevokePublicationAccess (
    string loginName
)

public:
void RevokePublicationAccess (
    String^ loginName
)

public void RevokePublicationAccess (
    String loginName
)

public function RevokePublicationAccess (
    loginName : String
)

Parameters

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

Exceptions

Exception type	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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms