Ubuntu Unleashed 2013 Edition: Covering 12.10 and 13.04, Eighth Edition

Deleting Database Users in PostgreSQL

To delete a database user, you use the dropuser command, along with the user’s name, and the user’s access is removed from the default database, like this:

matthew@seymour:~$  dropuser msmithDROP USER

You can also log in to your database by using psql and then use the DROP USER commands. Here is an example:

matthew@seymour:~$ psql demodbWelcome to psql, the PostgreSQL interactive terminal.Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit demodb=# DROP USER msmith ;DROP USERdemodb=# \q