granicus.if.org Git - postgresql/blob - doc/src/sgml/ref/drop_user.sgml

   1 <!--
   2 $Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_user.sgml,v 1.8 1999/12/04 04:53:15 momjian Exp $
   3 Postgres documentation
   4 -->
   5
   6 <refentry id="SQL-DROPUSER">
   7  <refmeta>
   8   <refentrytitle id="SQL-DROPUSER-TITLE">
   9    DROP USER
  10   </refentrytitle>
  11   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  12  </refmeta>
  13  <refnamediv>
  14   <refname>
  15    DROP USER
  16   </refname>
  17   <refpurpose>
  18    Removes an user account information
  19   </refpurpose>
  20  </refnamediv>
  21  <refsynopsisdiv>
  22   <refsynopsisdivinfo>
  23    <date>1999-07-20</date>
  24   </refsynopsisdivinfo>
  25   <synopsis>
  26 DROP USER <replaceable class="PARAMETER">name</replaceable>
  27   </synopsis>
  28
  29   <refsect2 id="R2-SQL-DROPUSER-1">
  30    <refsect2info>
  31     <date>1998-09-22</date>
  32    </refsect2info>
  33    <title>
  34     Inputs
  35    </title>
  36    <para>
  37
  38     <variablelist>
  39      <varlistentry>
  40       <term><replaceable class="PARAMETER">name</replaceable></term>
  41       <listitem>
  42        <para>
  43         The name of an existing user.
  44        </para>
  45       </listitem>
  46      </varlistentry>
  47     </variablelist>
  48    </para>
  49   </refsect2>
  50
  51   <refsect2 id="R2-SQL-DROPUSER-2">
  52    <refsect2info>
  53     <date>1998-09-22</date>
  54    </refsect2info>
  55    <title>
  56     Outputs
  57    </title>
  58    <para>
  59     <variablelist>
  60      <varlistentry>
  61       <term><computeroutput>
  62 DROP
  63        </computeroutput></term>
  64       <listitem>
  65        <para>
  66         The message returned if the user is successfully deleted.
  67        </para>
  68       </listitem>
  69      </varlistentry>
  70      <varlistentry>
  71       <term><computeroutput>
  72 ERROR: removeUser: user "<replaceable class="parameter">name</replaceable>" does not exist.
  73        </computeroutput></term>
  74       <listitem>
  75        <para>
  76         This message occurs if the username is not found.
  77        </para>
  78       </listitem>
  79      </varlistentry>
  80     </variablelist>
  81    </para>
  82   </refsect2>
  83  </refsynopsisdiv>
  84
  85  <refsect1 id="R1-SQL-DROPUSER-1">
  86   <refsect1info>
  87    <date>1998-09-22</date>
  88   </refsect1info>
  89   <title>
  90    Description
  91   </title>
  92   <para>
  93    <command>DROP USER</command> removes the specified
  94    user from the database,
  95    along with any databases owned by the user. It
  96    does not remove tables, views, or triggers owned by the
  97    named user in databases not owned by the user. This statement
  98    can be used in place of the <application>dropuser</application>
  99    script, regardless of how the user was created.
 100   </para>
 101
 102   <refsect2 id="R2-SQL-DROPUSER-3">
 103    <refsect2info>
 104     <date>1998-09-22</date>
 105    </refsect2info>
 106    <title>
 107     Notes
 108    </title>
 109    <para>
 110     <command>DROP USER</command> is a <productname>Postgres</productname>
 111     language extension.
 112    </para>
 113    <para>
 114     Refer to <command>CREATE USER</command> and
 115     <command>ALTER USER</command> for information on
 116     how to create or modify user accounts.
 117    </para>
 118   </refsect2>
 119  </refsect1>
 120
 121  <refsect1 id="R1-SQL-DROPUSER-2">
 122   <title>
 123    Usage
 124   </title>
 125   <para>
 126    To drop a user account:
 127    <programlisting>
 128 DROP USER Jonathan;
 129    </programlisting>
 130   </para>
 131  </refsect1>
 132
 133  <refsect1 id="R1-SQL-DROPUSER-3">
 134   <title>
 135    Compatibility
 136   </title>
 137
 138   <refsect2 id="R2-SQL-DROPUSER-4">
 139    <refsect2info>
 140     <date>1998-09-22</date>
 141    </refsect2info>
 142    <title>
 143     SQL92
 144    </title>
 145    <para>
 146     There is no <command>DROP USER</command> in <acronym>SQL92</acronym>.
 147    </para>
 148   </refsect2>
 149  </refsect1>
 150 </refentry>
 151
 152 <!-- Keep this comment at the end of the file
 153 Local variables:
 154 mode: sgml
 155 sgml-omittag:nil
 156 sgml-shorttag:t
 157 sgml-minimize-attributes:nil
 158 sgml-always-quote-attributes:t
 159 sgml-indent-step:1
 160 sgml-indent-data:t
 161 sgml-parent-document:nil
 162 sgml-default-dtd-file:"../reference.ced"
 163 sgml-exposed-tags:nil
 164 sgml-local-catalogs:"/usr/lib/sgml/catalog"
 165 sgml-local-ecat-files:nil
 166 End:
 167 -->