<!--
$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_user.sgml,v 1.7 1999/07/22 15:09:11 thomas Exp $
Postgres documentation
-->

<refentry id="SQL-DROPUSER">
 <refmeta>
  <refentrytitle id="SQL-DROPUSER-TITLE">
   DROP USER
  </refentrytitle>
  <refmiscinfo>SQL - Language Statements</refmiscinfo>
 </refmeta>
 <refnamediv>
  <refname>
   DROP USER
  </refname>
  <refpurpose>
   Removes an user account information
  </refpurpose>
 </refnamediv>
 <refsynopsisdiv>
  <refsynopsisdivinfo>
   <date>1999-07-20</date>
  </refsynopsisdivinfo>
  <synopsis>
DROP USER <replaceable class="PARAMETER">name</replaceable>
  </synopsis>
  
  <refsect2 id="R2-SQL-DROPUSER-1">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
    Inputs
   </title>
   <para>

    <variablelist>
     <varlistentry>
      <term><replaceable class="PARAMETER">name</replaceable></term>
      <listitem>
       <para>
	The name of an existing user.
       </para>
      </listitem>
     </varlistentry>
    </variablelist>
   </para>
  </refsect2>
  
  <refsect2 id="R2-SQL-DROPUSER-2">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
    Outputs
   </title>
   <para>
    <variablelist>
     <varlistentry>
      <term><computeroutput>
DROP
       </computeroutput></term>
      <listitem>
       <para>
	The message returned if the user is successfully deleted.
       </para>
      </listitem>
     </varlistentry>
     <varlistentry>
      <term><computeroutput>
ERROR: removeUser: user "<replaceable class="parameter">name</replaceable>" does not exist.
       </computeroutput></term>
      <listitem>
       <para>
	This message occurs if the username is not found.
       </para>
      </listitem>
     </varlistentry>
    </variablelist>
   </para>
  </refsect2>
 </refsynopsisdiv>

 <refsect1 id="R1-SQL-DROPUSER-1">
  <refsect1info>
   <date>1998-09-22</date>
  </refsect1info>
  <title>
   Description
  </title>
  <para>
   <command>DROP USER</command> removes the specified
   user from the database,
   along with any databases owned by the user. It
   does not remove tables, views, or triggers owned by the
   named user in databases not owned by the user. This statement
   can be used in place of the <application>destroyuser</application>
   script, regardless of how the user was created.
  </para>

  <refsect2 id="R2-SQL-DROPUSER-3">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
    Notes
   </title>
   <para>
    <command>DROP USER</command> is a <productname>Postgres</productname>
    language extension.
   </para>
   <para>
    Refer to <command>CREATE USER</command> and
    <command>ALTER USER</command> for information on
    how to create or modify user accounts.
   </para>
  </refsect2>
 </refsect1>

 <refsect1 id="R1-SQL-DROPUSER-2">
  <title>
   Usage
  </title>
  <para>
   To drop a user account:
   <programlisting>
DROP USER Jonathan;
   </programlisting>
  </para>
 </refsect1>
 
 <refsect1 id="R1-SQL-DROPUSER-3">
  <title>
   Compatibility
  </title>
  
  <refsect2 id="R2-SQL-DROPUSER-4">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
    SQL92
   </title>
   <para>
    There is no <command>DROP USER</command> in <acronym>SQL92</acronym>.
   </para>
  </refsect2>
 </refsect1>
</refentry>

<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:nil
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
sgml-parent-document:nil
sgml-default-dtd-file:"../reference.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:"/usr/lib/sgml/catalog"
sgml-local-ecat-files:nil
End:
-->
