Databases directly above the current database in a SQL Remote hierarchy are granted CONSOLIDATE permission by the current database. At each remote database, the consolidated database must be granted CONSOLIDATE permission.
CONSOLIDATE permission 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 permission 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. See SQL Remote message systems.
Send frequency When you use SQL statements to grant CONSOLIDATE permission, setting the send frequency is optional. See Setting the send frequency.
Granting CONSOLIDATE permission:
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 permissions on the same database. This would identify the publisher as both the sender and recipient of outgoing messages.
When a remote database is extracted by the Extraction utility (dbxtract) or the Extract Database Wizard, the GRANT CONSOLIDATE statement is executed automatically on the remote database.
Grant CONSOLIDATE permission
Revoke CONSOLIDATE permission
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |