Granting and revoking remote permission for SQL Remote

 Grant remote permissions to users (Sybase Central)

In Sybase Central, you can manage the remote permission of both users and groups. Remote permissions allow normal users and groups to become remote users in a SQL Remote replication setup to exchange replication messages with the consolidated database.

You cannot grant remote permissions to a user until you define at least one message type in the database.

To grant remote permissions to a group, you must explicitly grant remote permissions to each user in the group. Remote permissions are not inherited by members of a group.

After granting a user remote permissions, you can subscribe the user to publications.

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

  2. Click Users & Groups.

  3. Right-click a user and then click Change To Remote User.

  4. Complete the fields and click OK.

 Revoke remote permissions from remote users (Sybase Central)

Revoking remote permissions reverts a remote user to a normal user. Revoking these permissions also automatically unsubscribes that user from all publications.

  1. Connect to the database as a user with DBA authority.

  2. Click Users & Groups or SQL Remote Users.

  3. Right-click a user and then click Revoke Remote.

  4. Click Yes.

 See also