Vertica Analytics Platform Version 9.2.x Documentation

DROP ROLE

Removes a role from the database.

You cannot use DROP ROLE on a role added to the Vertica database with the LDAPLink service.

Syntax

DROP ROLE [ IF EXISTS ] role‑name[,…] [ CASCADE ]

Parameters

IF EXISTS

Specifies not to report an error if the roles to drop do not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.

role‑name

The name of the role to drop

CASCADE

Revoke the role from users and other roles before dropping the role

Privileges

Superuser

Examples

=> DROP ROLE appadmin;
NOTICE:  User bob depends on Role appadmin
ROLLBACK:  DROP ROLE failed due to dependencies
DETAIL:  Cannot drop Role appadmin because other objects depend on it
HINT:  Use DROP ROLE ... CASCADE to remove granted roles from the dependent users/roles
=> DROP ROLE appadmin CASCADE;
DROP ROLE