Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-02382

profile string has users assigned, cannot drop without CASCADE

Cause

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 had users assigned to it cannot be dropped, unless the CASCADE option was specified. CASCADE reassigns users to the PUBLIC_DEFAULT profile before dropping the profile.


Action

To reassign all users to the PUBLIC_DEFAULT profile, issue the DROP PROFILE statement with the CASCADE option.