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 its 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
Related Views:
DBA_PROFILES
DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS
V$SESSION
V$SESSION_CONNECT_INFO
V$SESSTAT
V$SESS_IO