Filter
Top Products
Chapter 16. System Objects for Adaptive Server Enterprise
publisher address.
Columns
Column Data type Description
type_id INT An identification number for the
message type.
type_name VARCHAR(128) The message type. There is a sepa-
rate row for each of the following:
♦ FILE
♦ MAPI
♦ VIM
♦ SMTP
publisher_-
address
VARCHAR(128) The publisher’s address for the
message type type_name.
sr_remoteuser table
Function Each row describes a user ID with REMOTE permissions (a subscriber),
together with the status of SQL Remote messages sent to and from that user.
Columns
Column Data type Description
user_id INT The user ID of the user with RE-
MOTE permissions.
consolidate CHAR(1) The column contains either an N to
indicate a user granted REMOTE
permissions, or a Y to indicate a user
granted CONSOLIDATE permis-
sions.
type_id INT The ID of the message system used
to send messages to this user.
address VARCHAR(128) The address to which SQL Remote
messages are to be sent. The address
must be appropriate for the address_-
type.
343