User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To stop a user from being able to receive SQL Remote messages from this database.

Syntax

     REVOKE REMOTE FROM userid,...

Usage

Anywhere. This statement is applicable only to SQL Remote.

Permissions

Must have DBA authority.

Side effects

Automatic commit. Drops all subscriptions for the user.

Description

REMOTE permissions are required for a user ID to receive messages in a SQL Remote replication installation. The REVOKE REMOTE statement removes a user ID from the list of users receiving messages from the current database.

Example

     REVOKE REMOTE FROM SamS