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.

"Smoking kills. If you're killed, you've lost a very important part of your life." - Brooke Shields, during an interview to become spokesperson for a federal anti-smoking campaign.

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