DROP PROFILE

Drop a user profile

Syntax:

   DROP PROFILE profile_name [CASCADE]

If a user is currently assigned to a profile, then the profile cannot be dropped, specifying CASCADE will remove all such profile assignments before dropping the profile itself.

If you do manage to disconnect a user account from it's assigned profile e.g. via export and import, you will then find the account is unable to login (invalid username/password) to resolve this, recreate the profile or assign the user to a different profile (ALTER USER…)

"I would rather train someone and lose them, then not train them and keep them" ~ Zig Ziglar

Related Oracle Commands:

PROFILE - CREATE PROFILE
PROFILE - ALTER PROFILE
ROLE - DROP ROLE