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 _
)
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
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
Publication Class
Publication Members
Microsoft.SqlServer.Replication Namespace