Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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).