- If a journal table exists for the user, drop the journal table:
MODIFY USER user_name AS DROP DEFAULT JOURNAL TABLE; - Delete all database objects from the user:
DELETE USER user_name ALL; - Drop the user:
DROP USER user_name;
MODIFY USER user_name AS DROP DEFAULT JOURNAL TABLE;
DELETE USER user_name ALL;
DROP USER user_name;