DROP USER
  
  SQL - Language Statements
 
 
  
   DROP USER
  
  
   Removes an user account information
  
 
 
  
   1999-07-20
  
  
DROP USER name
  
  
  
   
    1998-09-22
   
   
    Inputs
   
   
    
     
      name
      
       
	The name of an existing user.
       
      
     
    
   
  
  
  
   
    1998-09-22
   
   
    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.
       
      
     
    
   
  
 
 
  
   1998-09-22
  
  
   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.
  
  
   
    1998-09-22
   
   
    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
  
  
  
   
    1998-09-22
   
   
    SQL92
   
   
    There is no DROP USER in SQL92.