Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions » Managing individual user IDs and permissions

Execution permissions of triggers Next Page

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 a database.

  2. Open the Users & Groups folder.

  3. Select the desired user and then choose File > Change to Remote User.

    The Change User to Remote User dialog appears.

  4. In the resulting dialog, enter the desired values.

Once you have granted remote permissions to a user, you can subscribe it to publications:

To revoke remote permissions from remote users
  1. Open either the Users & Groups folder or the SQL Remote Users folder.

  2. Select the desired remote user and then choose File > Revoke Remote.

  3. See SQL Remote Concepts.