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

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Creating SQL Remote systems » User privileges



Databases directly above the current database in a SQL Remote hierarchy are granted CONSOLIDATE privilege by the current database. At each remote database, the consolidated database must be granted CONSOLIDATE privilege.

CONSOLIDATE privilege must be granted even from read-only remote databases to the consolidated database, because receipt confirmations are sent from the remote databases to the consolidated database.

When granting CONSOLIDATE privilege to a user, you must configure the following settings:

  • Message system   You cannot create a new consolidated user until at least one message system is defined in the database.

  • Send frequency   When you use SQL statements to grant CONSOLIDATE privilege, setting the send frequency is optional.

Granting CONSOLIDATE privilege:

  • Identifies a user as a consolidated user.

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

  • Provides an address to send messages to.

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

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

 Extraction utility (dbxtract)
 See also

Granting CONSOLIDATE privilege
Revoking CONSOLIDATE privilege