Tag Archives: ORA-02382

ORA-02382: profile string has users assigned, cannot drop without CASCADE

oracle

ORA-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 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: To reassign all users to the PUBLIC_DEFAULT profile, issue the DROP PROFILE statement with the CASCADE option.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/