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.

"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



Back to the Top

Simon Sheppard
SS64.com