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 _
)
'Usage
Dim instance As Publication
Dim loginName As String
instance.RevokePublicationAccess(loginName)
public void RevokePublicationAccess(
string loginName
)
public:
void RevokePublicationAccess(
String^ loginName
)
member RevokePublicationAccess :
loginName:string -> unit
public function RevokePublicationAccess(
loginName : String
)
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).