Filter
Top Products
GRANT CONSOLIDATE statement
Function 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.
Syntax GRANT CONSOLIDATE
TO userid, . ..
TYPE message-system, . . .
ADDRESS address-string, .. .
[ SEND { EVERY | AT }’hh:mm: ss’ ]
message-system: FILE | FTP | MAPI | SMTP | VIM
address: string
Parameters
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.
Permissions Must have DBA authority.
Side effects Automatic commit.
See also “GRANT CONSOLIDATE statement [SQL Remote]” [ASA SQL Reference,
page 508]
“GRANT REMOTE statement” on page 366
“REVOKE CONSOLIDATE statement” on page 370
“GRANT PUBLISH statement” on page 365
“sp_grant_consolidate procedure” on page 390
364