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

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » User permissions


REMOTE permission

Granting REMOTE permission is also referred to as adding a remote user to the database. Publishers of databases directly below the current database in a SQL Remote hierarchy are granted REMOTE permission by the current database.

When granting REMOTE permission to a user, you must configure the following settings:

  • Message system   You cannot create a new remote user until at least one message system is defined in the database. See SQL Remote message systems.

  • Send frequency   When you use SQL statements to grant REMOTE permission, setting the send frequency is optional. See Setting the send frequency.

Granting REMOTE permission to a user:

  • Identifies the user as a remote user.

  • Specifies a message type to use for exchanging messages with this remote user.

  • Provides an address to send messages to.

  • Indicates how often messages should be sent to the remote user.

The publisher for a database cannot have REMOTE and CONSOLIDATE permission on the same database. This would identify the publisher as both the sender and recipient of outgoing messages.

Granting REMOTE permission to groups

Although, you can grant REMOTE permission to a group, the REMOTE permission does not automatically apply to all users in the group. You must explicitly grant REMOTE permission to each user in the group..

Grant REMOTE permission
Revoke REMOTE permission