Contents Index Selecting a send frequency Revoking REMOTE and CONSOLIDATE permissions

SQL Remote User's Guide
  SQL Remote Administration
    Managing SQL Remote permissions
      Granting and revoking REMOTE and CONSOLIDATE permissions

Granting CONSOLIDATE permissions

In the remote database, the publish and subscribe user IDs are inverted compared to the consolidated database. The subscriber (remote user) in the consolidated database becomes the publisher in the remote database. The publisher of the consolidated database becomes a subscriber to publications from the remote database, and is granted CONSOLIDATE permissions.

At each remote database, the consolidated database must be granted CONSOLIDATE permissions. When you produce a remote database by running the database extraction utility, the GRANT CONSOLIDATE statement is executed automatically at the remote database.

Adaptive Server Anywhere example 

The following Adaptive Server Anywhere statement grants CONSOLIDATE permissions to the hq_user user ID, using the VIM e-mail system:

GRANT CONSOLIDATE TO hq_user
TYPE vim
ADDRESS 'hq_address'

There is no SEND clause in this statement, so the default is used and messages will be sent to the consolidated database every time the Message Agent is run.

Adaptive Server Enterprise example 

The following Adaptive Server Enterprise statement grants CONSOLIDATE permissions to user hq_user, using the file message link:

exec sp_grant_consolidate 'hq_user', 'file', address
go

Contents Index Selecting a send frequency Revoking REMOTE and CONSOLIDATE permissions