dropuser

removes an existing role from Greenplum Database. 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.

role_name

The name of the role to be removed. You will be prompted for a name if not specified on the command line and the / --interactive option is used.

-e | –echo

Echo the commands that dropuser generates and sends to the server.

-i | –interactive

Prompt for confirmation before actually removing the role, and prompt for the role name if none is specified on the command line.

Do not throw an error if the user does not exist. A notice is issued in this case.

-V | –version

Print the dropuser version and exit.

-? | –help

Show help about command line arguments, and exit.

Connection Options

-h host | –host=host

The host name of the machine on which the Greenplum master database server is running. If not specified, reads from the environment variable PGHOST or defaults to localhost.

The TCP port on which the Greenplum master database server is listening for connections. If not specified, reads from the environment variable PGPORT or defaults to 5432.

-U username | –username=username

The database role name to connect as. If not specified, reads from the environment variable PGUSER or defaults to the current system role name.

-w | –no-password

Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a 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.

-W | –password

Force a password prompt.

To remove the role joe using default connection options:

, DROP ROLE