DROP PROFILE
Removes a user-defined profile (created by CREATE PROFILE) from the database. You cannot drop the DEFAULT profile.
Syntax
DROP PROFILE [ IF EXISTS ] profile‑name[,…] [ CASCADE ]
Parameters
IF EXISTS
|
Specifies not to report an error if the profile to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them. |
| profile‑name |
The profile to drop. |
CASCADE
|
Moves all users assigned to the dropped profiles to the DEFAULT profile. If you omit this option and a targeted profile has users assigned to it, Vertica returns an error. |
Privileges
Superuser
Example
=> DROP PROFILE sample_profile;