User's Manual

sp_grant_consolidate procedure

Purpose To identify a database immediately above the current database in a

SQL Remote hierarchy, who will receive messages from the current

database. This procedure applies only to Adaptive Server Enterprise

databases acting as remote databases.

Syntax sp_grant_consolidate user_name,

type_name,

address

[, frequency ]

[, send_time ]

Argument Description

user_name

The user ID who will be able to receive SQL Remote

messages.

type_name

The message type to be used. This must be one of the

following:

♦ ﬁle

♦ ftp

♦ smtp

♦ mapi

♦ vim

address

A string holding the address, according to the speci-

ﬁed 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 speciﬁed by

send_time

♦ SEND AT Indicates that messages are sent at a

time of day speciﬁed by

send_time

390