sp_grant_consolidate procedure
Purpose Toidentify a database immediately above the current database in a
SQLRemote hierarchy, who will receive messages from the current
database. This procedure applies only to Adaptive Server Enterprise
databasesacting as remote databases.
Syntax sp_grant_consolidate user_name,
type_name,
address
[,frequency ]
[,send_time ]
Argument Description
user_name
Theuser ID who will be able to receive SQL Remote
messages.
type_name
Themessage type to be used. Thismust be one of the
following:
♦file
♦ftp
♦smtp
♦mapi
♦vim
address
A string holding the address, according to the speci-
fiedmessage type, to which the replication messages
shouldbe sent for this user.
frequency
Astring containing one of the following:
♦SENDEVERY Indicatesthat messages are sent
ata frequency specified by
send_time
.
♦SEND AT Indicates that messages are sent at a
timeof day specified by
send_time
.