SQL Remote User's Guide
Command Reference for Adaptive Server Anywhere
Use this statement to identify the database immediately above the current database in a SQL Remote hierarchy, who will receive messages from the current database.
GRANT CONSOLIDATE
TO userid, ...
TYPE message-system, ...
ADDRESS address-string, ...
[ SEND { EVERY | AT }'hh:mm' ]
message-system: FILE | FTP | MAPI | SMTP | VIM
address: string
| Parameter | Description |
|---|---|
| userid | The user ID for the user to be granted the permission |
| message-system | One of the message systems supported by SQL Remote. |
| address | The address for the specified message system. |
Must have DBA authority.
Automatic commit.
GRANT CONSOLIDATE statement [SQL Remote]
sp_grant_consolidate procedure