DROP_USER(l)                                         DROP_USER(l)

NAME
       DROP USER - Removes an user account information

SYNOPSIS
       DROP USER name

   INPUTS
       name   The name of an existing user.

   OUTPUTS
       DROP   The  message  returned  if the user is successfully
              deleted.

       ERROR: removeUser: user "name" does not exist.
              This message occurs if the username is not found.

DESCRIPTION
       DROP USER 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 destroyuser script, regardless of how
       the user was created.

   NOTES
       DROP USER is a Postgres language extension.

       Refer to CREATE USER and ALTER USER for information on how
       to create or modify user accounts.

USAGE
       To drop a user account:

       DROP USER Jonathan;

COMPATIBILITY
   SQL92
       There is no DROP USER in SQL92.

SQL - Language Statements 15 August 1999                        1