dropuser
Removes a database role.
Synopsis
dropuser [<connection_options>] [-e | --echo] [-i | --interactive] <role_name>
dropuser --help
dropuser --version
Description
dropuser
removes an existing role from HAWQ. Only superusers and users with the CREATEROLE
privilege can remove roles. To remove a superuser role, you must yourself be a superuser.
dropuser
is a wrapper around the SQL command DROP ROLE
.
Arguments
Options
dropuser
generates and sends to the server.<connection_options>
PGHOST
or defaults to localhost.PGPORT
or defaults to 5432.PGUSER
or defaults to the current system role name..pgpass
file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password.Other Options
Examples
To remove the role joe
using default connection options:
$ dropuser joe
To remove the role joe
using connection options, with verification, and a peek at the underlying command:
$ dropuser -p 54321 -h masterhost -i -e joe
Role "joe" will be permanently removed.
Are you sure? (y/n) y
DROP ROLE "joe"