Index Index for
Section USER
Index Alphabetical
listing for D
Bottom of page Bottom of
page		 

DROP


NAME

  DROP USER - remove a database user account


SYNOPSIS

  DROP USER name


DESCRIPTION

  DROP USER removes the specified user from the database.  It does not remove
  tables, views, or other objects owned by the user. If the user owns any
  database, an error is raised.

  PARAMETERS

  name The name of an existing user.


DIAGNOSTICS

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

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

  DROP USER: user "name" owns database "name", cannot be removed
       You must drop the database first or change its ownership.


NOTES

  Use CREATE USER [create_user(5)] to add new users, and ALTER USER
  [alter_user(5)] to change a user's attributes.  PostgreSQL includes a
  program dropuser [dropuser(1)] that has the same functionality as this
  command (in fact, it calls this command) but can be run from the command
  shell.


EXAMPLES

  To drop a user account:

  DROP USER jonathan;


COMPATIBILITY

  The DROP USER statement is a PostgreSQL extension. The SQL standard leaves
  the definition of users to the implementation.


SEE ALSO

  CREATE USER [create_user(5)], ALTER USER [alter_user(l)], dropuser(1)

Index Index for
Section USER
Index Alphabetical
listing for D
Top of page Top of
page