If the profile is used by a user in the database, the DROP PROFILE statement will fail. This is the default.