Use the SQL Anywhere 12 plug-in to connect to the consolidated database as a user with DBA authority.

In the left pane, expand either the Users & Groups folder or the SQL Remote Users folder.

Right-click the remote user or group and choose Revoke Remote.

Connect to the database as a user with DBA authority.

Execute a REVOKE REMOTE statement to revoke the REMOTE permission from the current user or group. See REVOKE REMOTE statement [SQL Remote].

For example, the following statement revokes REMOTE permission from user S_Beaulieu.

REVOKE REMOTE FROM S_Beaulieu;