Contents Index SYSPUBLICATION system table SYSREMOTEOPTIONTYPE system table

ASA SQL Reference
  System Tables

SYSREMOTEOPTION system table


Function 

Each row describes the values of a SQL Remote message link parameter.

Columns 
Column Data type Column Constraint Table constraints
option_id UNSIGNED INT NOT NULL Primary key
user_id UNSIGNED INT NOT NULL Primary key
"setting" VARCHAR(255) NOT NULL

Some columns in this table contain potentially sensitive data. For that reason, access to this table is restricted to users with DBA authority. The SYSREMOTEOPTION2 view provides public access to the data in this table except for the potentially sensitive columns.

option_id    An identification number for the message link parameter.

user_id    The user ID for which the parameter is set.

setting    The value of the message link parameter.


Contents Index SYSPUBLICATION system table SYSREMOTEOPTIONTYPE system table