current_user.sgml
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:3k
源码类别:

数据库系统

开发平台:

Unix_Linux

  1. <REFENTRY ID="SQL-CURRENT-USER">
  2.  <REFMETA>
  3.   <REFENTRYTITLE>
  4.    SQL_CURRENT_USER
  5.   </REFENTRYTITLE>
  6.   <REFMISCINFO>SQL - Functions</REFMISCINFO>
  7.  </REFMETA>
  8.  <REFNAMEDIV>
  9.   <REFNAME>
  10.    CURRENT_USER
  11.   </REFNAME>
  12.   <REFPURPOSE>
  13.    Returns the current user name
  14.   </REFPURPOSE>
  15.  <REFSYNOPSISDIV>
  16.   <REFSYNOPSISDIVINFO>
  17.    <DATE>1998-04-15</DATE>
  18.   </REFSYNOPSISDIVINFO>
  19.   <SYNOPSIS>
  20.    CURRENT_USER 
  21.   </SYNOPSIS>
  22.   
  23.   <REFSECT2 ID="R2-SQL-CURRENT-USER-1">
  24.    <REFSECT2INFO>
  25.     <DATE>1998-04-15</DATE>
  26.    </REFSECT2INFO>
  27.    <TITLE>
  28.     Inputs
  29.    </TITLE>
  30.    <PARA>
  31. None.
  32.   </REFSECT2>
  33.   
  34.   <REFSECT2 ID="R2-SQL-CURRENT-USER-2">
  35.    <REFSECT2INFO>
  36.     <DATE>1998-04-15</DATE>
  37.    </REFSECT2INFO>
  38.    <TITLE>
  39.     Outputs
  40.    </TITLE>
  41.    <PARA>
  42.        <VARIABLELIST>
  43. <VARLISTENTRY>
  44.  <TERM>
  45.   <replaceable>username</replaceable>
  46.  </TERM>
  47.  <LISTITEM>
  48.   <PARA>
  49. The name of the current user.
  50.    </VARIABLELIST>
  51.   </REFSECT2>
  52.  </REFSYNOPSISDIV>
  53.  
  54.  <REFSECT1 ID="R1-SQL-CURRENT-USER-1">
  55.   <REFSECT1INFO>
  56.    <DATE>1998-04-15</DATE>
  57.   </REFSECT1INFO>
  58.   <TITLE>
  59.    Description
  60.   </TITLE>
  61.   <PARA>
  62.    The niladic CURRENT_USER function returns a string of type "name"
  63.    whose value represents a user name identification.
  64.   </PARA>
  65.   
  66.   <REFSECT2 ID="R2-SQL-CURRENT-USER-3">
  67.    <REFSECT2INFO>
  68.     <DATE>1998-04-15</DATE>
  69.    </REFSECT2INFO>
  70.    <TITLE>
  71.     Notes
  72.    </TITLE>
  73.    <PARA>
  74.     Data type "name" is a non-standard 31-character type for storing
  75.     system identifiers.
  76.    </PARA>
  77.   </REFSECT2>
  78.   
  79.  <REFSECT1 ID="R1-SQL-CURRENT-USER-2">
  80.   <TITLE>
  81.    Usage
  82.   </TITLE>
  83.   <PARA>
  84.    Display CURRENT_USER
  85.   </PARA>
  86.   <ProgramListing>
  87.    SELECT CURRENT_USER AS who_am_i;
  88.    who_am_i
  89.    ------------
  90.    jose
  91.   </ProgramListing>
  92.  </REFSECT1>
  93.  
  94.  <REFSECT1 ID="R1-SQL-CURRENT-USER-3">
  95.   <TITLE>
  96.    Compatibility
  97.   </TITLE>
  98.   <PARA>
  99.   </PARA>
  100.   
  101.   <REFSECT2 ID="R2-SQL-CURRENT-USER-4">
  102.    <REFSECT2INFO>
  103.     <DATE>1998-04-15</DATE>
  104.    </REFSECT2INFO>
  105.    <TITLE>
  106.     SQL92
  107.    </TITLE>
  108.    <PARA>
  109.    SQL92 specifies some additional niladic USER functions:
  110.    </PARA>
  111.    <variablelist>
  112.     <varlistentry>
  113.      <term>CURRENT_USER / USER</term>
  114.      <listitem>
  115.       <para>  
  116.        USER is a synonym for CURRENT_USER. 
  117.       </para>
  118.      </listitem>
  119.     </varlistentry>
  120.     <varlistentry>
  121.      <term>SESSION_USER</term>
  122.      <listitem>
  123.       <para>
  124.        The SESSION_USER function returns the SQL-session user name.
  125.       </para>
  126.      </listitem>
  127.     </varlistentry>
  128.     <varlistentry>
  129.      <term>SYSTEM_USER</term>
  130.      <listitem>
  131.       <para>
  132.        The SYSTEM_USER function returns the database's initial default user.
  133.       </para>
  134.      </listitem>
  135.     </varlistentry>
  136.    </variablelist>
  137.    <para>
  138.     A niladic USER function returns a SQL_TEXT character string whose
  139.     value represents a user name.
  140.    </para>
  141.   </refsect2>
  142.  </refsect1>
  143. </REFENTRY>
  144. <!-- Keep this comment at the end of the file
  145. Local variables:
  146. mode: sgml
  147. sgml-omittag:t
  148. sgml-shorttag:t
  149. sgml-minimize-attributes:nil
  150. sgml-always-quote-attributes:t
  151. sgml-indent-step:1
  152. sgml-indent-data:t
  153. sgml-parent-document:nil
  154. sgml-default-dtd-file:"../reference.ced"
  155. sgml-exposed-tags:nil
  156. sgml-local-catalogs:"/usr/lib/sgml/catalog"
  157. sgml-local-ecat-files:nil
  158. End:
  159. -->