Sybase SQL Remote DC38133-01-0902-01 User Manual
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.
message type.
type_name
VARCHAR(128)
The message type. There is a sepa-
rate row for each of the following:
rate row for each of the following:
♦
FILE
♦
MAPI
♦
VIM
♦
SMTP
publisher_-
address
address
VARCHAR(128)
The publisher’s address for the
message type type_name.
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.
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.
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.
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.
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.
messages are to be sent. The address
must be appropriate for the address_-
type.
343