Granting REMOTE privilege 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 privilege by the current database.
When granting REMOTE privilege 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.
Send frequency When you use SQL statements to grant REMOTE privilege, setting the send frequency is optional
Granting REMOTE privilege 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 privilege on the same database. This would identify the publisher as both the sender and recipient of outgoing messages.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|