|
The SYSUSEROPTIONS view contains the option settings that are in effect for each user. If a user has no setting for an option, this view displays the public setting for the option.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
ALTER VIEW "SYS"."SYSUSEROPTIONS"( user_name,
"option",setting)
as select u.name,
o."option",
isnull((select s.setting from
SYS.SYSOPTIONS as s where
s.user_name = u.name and
s."option" = o."option"),
o.setting) from
SYS.SYSOPTIONS as o,SYS.SYSUSERAUTH as u where
o.user_name = 'PUBLIC'