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 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


© Copyright SS64.com 1999-2014
Some rights reserved