Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere 服务器 - SQL 参考 » 视图 » 统一视图

 

SYSUSEROPTIONS 统一视图

SYSUSEROPTIONS 视图包含了对每个用户都有效的选项设置。如果用户没有某个选项的设置,该视图将显示该选项的公共设置。

在以下的 SQL 语句中提供了组成该视图的表和列。要了解有关特定表或列的详细信息,请使用该视图定义下所提供的链接。



ALTER VIEW "SYS"."SYSUSEROPTIONS"( user_name,
  "option",setting ) 
  as select u.user_name,
    o."option",
    isnull((select s.setting
      from SYS.ISYSOPTION as s
      where s.user_id = u.user_id
      and s."option" = o."option"),
    o.setting)
    from SYS.SYSOPTIONS as o,SYS.ISYSUSER as u
    where o.user_name = 'PUBLIC'
 另请参见