Sybase SQL Remote DC38133-01-0902-01 Benutzerhandbuch
Chapter 18. Command Reference for Adaptive Server Enterprise
sp_grant_remote procedure
Purpose
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.
SQL Remote hierarchy, who will receive messages from the current
database. These are called remote users.
Syntax
sp_grant_remote user_name,
type_name,
address
[, frequency ]
[, send_time ]
type_name,
address
[, frequency ]
[, send_time ]
Argument
Description
user_name
The user ID who will be able to receive SQL Remote
messages.
messages.
type_name
The message type to be used. This must be one of the
following:
following:
♦
file
♦
ftp
♦
smtp
♦
mapi
♦
vim
address
A string holding the address, according to the speci-
fied message type, to which the replication messages
should be sent for this user.
fied message type, to which the replication messages
should be sent for this user.
frequency
A string containing one of the following:
♦
SEND EVERY
Indicates that messages are sent
at a frequency specified by
send_time.
♦
SEND AT
Indicates that messages are sent at a
time of day specified by
send_time.
393