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

数据库系统

开发平台:

Unix_Linux

  1. <refentry id="SQL-DROPUSER">
  2.  <refmeta>
  3.   <refentrytitle>
  4.    DROP USER
  5.   </refentrytitle>
  6.   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  7.  </refmeta>
  8.  <refnamediv>
  9.   <refname>
  10.    DROP USER
  11.   </refname>
  12.   <refpurpose>
  13.    Removes an user account information
  14.   </refpurpose>
  15.  </refnamediv>
  16.  <refsynopsisdiv>
  17.   <refsynopsisdivinfo>
  18.    <date>1998-09-22</date>
  19.   </refsynopsisdivinfo>
  20.   <synopsis>
  21. DROP USER <replaceable class="PARAMETER">name</replaceable>
  22.   </synopsis>
  23.   
  24.   <refsect2 id="R2-SQL-DROPUSER-1">
  25.    <refsect2info>
  26.     <date>1998-09-22</date>
  27.    </refsect2info>
  28.    <title>
  29.     Inputs
  30.    </title>
  31.    <para>
  32.     <variablelist>
  33.      <varlistentry>
  34.       <term><replaceable class="PARAMETER">name</replaceable></term>
  35.       <listitem>
  36.        <para>
  37. The name of an existing user.
  38.        </para>
  39.       </listitem>
  40.      </varlistentry>
  41.     </variablelist>
  42.    </para>
  43.   </refsect2>
  44.   
  45.   <refsect2 id="R2-SQL-DROPUSER-2">
  46.    <refsect2info>
  47.     <date>1998-09-22</date>
  48.    </refsect2info>
  49.    <title>
  50.     Outputs
  51.    </title>
  52.    <para>
  53.     <variablelist>
  54.      <varlistentry>
  55.       <term><computeroutput>
  56. DROP
  57.        </computeroutput></term>
  58.       <listitem>
  59.        <para>
  60. The message returned if the user is successfully deleted.
  61.        </para>
  62.       </listitem>
  63.      </varlistentry>
  64.      <varlistentry>
  65.       <term><computeroutput>
  66. ERROR: removeUser: user "<replaceable class="parameter">name</replaceable>" does not exist.
  67.        </computeroutput></term>
  68.       <listitem>
  69.        <para>
  70. This message occurs if the username is not found.
  71.        </para>
  72.       </listitem>
  73.      </varlistentry>
  74.     </variablelist>
  75.    </para>
  76.   </refsect2>
  77.  </refsynopsisdiv>
  78.  <refsect1 id="R1-SQL-DROPUSER-1">
  79.   <refsect1info>
  80.    <date>1998-09-22</date>
  81.   </refsect1info>
  82.   <title>
  83.    Description
  84.   </title>
  85.   <para>
  86.    <command>DROP USER</command> removes the specified
  87.    user from the database,
  88.    along with any databases owned by the user. It
  89.    does not remove tables, views, or triggers owned by the
  90.    named user in databases not owned by the user. This statement
  91.    can be used in place of the <application>destroyuser</application>
  92.    script, regardless of how the user was created.
  93.   </para>
  94.   <refsect2 id="R2-SQL-DROPUSER-3">
  95.    <refsect2info>
  96.     <date>1998-09-22</date>
  97.    </refsect2info>
  98.    <title>
  99.     Notes
  100.    </title>
  101.    <para>
  102.     <command>DROP USER</command> is a <productname>Postgres</productname>
  103.     language extension.
  104.    </para>
  105.    <para>
  106.     Refer to <command>CREATE USER</command> and
  107.     <command>ALTER USER</command> for information on
  108.     how to create or modify user accounts.
  109.    </para>
  110.   </refsect2>
  111.  </refsect1>
  112.  <refsect1 id="R1-SQL-DROPUSER-2">
  113.   <title>
  114.    Usage
  115.   </title>
  116.   <para>
  117.    To drop a user account:
  118.    <programlisting>
  119. DROP USER Jonathan;
  120.    </programlisting>
  121.   </para>
  122.  </refsect1>
  123.  
  124.  <refsect1 id="R1-SQL-DROPUSER-3">
  125.   <title>
  126.    Compatibility
  127.   </title>
  128.   <para>
  129.   </para>
  130.   
  131.   <refsect2 id="R2-SQL-DROPUSER-4">
  132.    <refsect2info>
  133.     <date>1998-09-22</date>
  134.    </refsect2info>
  135.    <title>
  136.     SQL92
  137.    </title>
  138.    <para>
  139.     There is no <command>DROP USER</command> in <acronym>SQL92</acronym>.
  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:nil
  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. -->