Sybase SQL Remote DC38133-01-0902-01 User Manual
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.
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 }
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
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
364