SQL Remote User's Guide
  Command Reference for Adaptive Server Anywhere

REVOKE REMOTE statement

Function 

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

Syntax 

REVOKE REMOTE FROM userid, ...

Permissions 

Must have DBA authority.

Side effects 

Automatic commit. Drops all subscriptions for the user.

See also 

REVOKE REMOTE statement [SQL Remote]

sp_revoke_remote procedure