Sybase SQL Remote DC38133-01-0902-01 User 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.
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 }
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
system
One of the message systems supported by SQL Remote. It
must be one of the following values:
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.
message system.
send-time
A string containing a time specification in the form
hh :mm:ss.
hh :mm:ss.
Permissions
Must have DBA authority.
Side effects
Automatic commit.
See also
366