Oracle DB Error ORA-02382 profile string has users assigned, cannot drop without CASCADE

The following is the cause of this error:

An attempt was made to drop a profile that had users assigned to it without using the CASCADE option of the DROP PROFILE statement. A profile that has users assigned to it cannot be dropped, unless the CASCADE option is specified. CASCADE reassigns users to the PUBLIC_DEFAULT profile before dropping the profile.

Action you can take to resolve this issue: To reassign all users to the PUBLIC_DEFAULT profile, issue the DROP PROFILE statement with the CASCADE option.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related