Drop User in Vertica

Drop user will simply drop a user form the database.

DROP USER name [ CASCADE ];

The CASCADE option will drop all objects created by the user dropped, including schema, table and all views that reference the table, and the table's associated projections.

drop user TEST ;
 --     or
drop user TEST CASCADE;

If the user that is droped has objects owned in the database and the CASCADE option is not used an error will be received.