Granting and revoking remote permissions

In Sybase Central, you can manage the remote permissions 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 publishing database.

Granting remote permissions

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.

Revoking remote permissions

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

To grant remote permissions to users (Sybase Central)
  1. Connect to the database as a user with DBA authority.

  2. Click Users & Groups.

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

  4. Complete the fields and click OK.

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

To revoke remote permissions from remote users
  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 choose Revoke Remote.

  4. Click Yes.

See SQL Remote introduction.