User's Manual

GRANT REMOTE statement
Function Use this statement to identify a database immediately below the current
database in a SQL Remote hierarchy, who will receive messages from the
current database. These are called remote users.
Syntax GRANT REMOTE TO userid, . . .
TYPE message-system, . . .
ADDRESS address-string, . . .
[ SEND { EVERY | AT } ’send-time’ ]
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. It
must be one of the following values:
♦ FILE
♦ FTP
♦ MAPI
♦ SMTP
♦ VIM
address-string A string containing a valid address for the specified
message system.
send-time A string containing a time specification in the form
hh : mm : ss .
Permissions Must have DBA authority.
Side effects Automatic commit.
See also “GRANT REMOTE statement [SQL Remote]” [ASA SQL Reference, page 511]
“GRANT CONSOLIDATE statement” on page 364
“REVOKE REMOTE statement” on page 372
“GRANT PUBLISH statement” on page 365
“sp_grant_remote procedure” on page 393
“Granting and revoking REMOTE and CONSOLIDATE permissions” on
page 204
366