CREATE VIEW SYS.SYSREMOTEOPTIONS
AS
SELECT type_name,
user_name,
"option",
setting
FROM SYS.SYSREMOTETYPE AS srt,
SYS.SYSREMOTEOPTIONTYPE AS srot,
SYS.SYSREMOTEOPTION AS sro,
SYS.SYSUSERPERM AS sup
WHERE srt.type_id = srot.type_id
AND srot.option_id = sro.option_id
AND sro.user_id = sup.user_id
Presents the data from the system tables SYSREMOTEOPTION and SYSREMOTEOPTIONTYPE in a more readable format.