This article provides information on how to prevent the privileges issue while dropping the view.
Environment:
Vertica analytics Database: v24.3.x
Situation:
Even though the user is schema owner, drop statement is failing with insufficient privileges issue,
[Vertica] [VJDBC] (8959) ROLLBACK: Insufficient privileges on <view_name>, drop privileges needed
Find resolution on support portal
