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.