Syntax for Securing Global Resources › DROP USER PROFILE › DROP USER PROFILE Usage

DROP USER PROFILE Usage

Users Associated With Profiles That are Dropped

If you drop a profile specified in a user definition, no user profile attributes will be associated with the user session.

The following DROP USER PROFILE statement removes the definition of the hr_prof profile from the user catalog:

drop user profile hr_prof;