Database Reference
In-Depth Information
Example 4:
The following statement creates a user profile called
InventoryProfile
.
The parameters not specified will have default values.
As expected, Oracle allows you to modify or drop a profile via the
Alter-Profile
statement, or the
Drop-Profile
statement respectively. The syntax for each is shown
below (Figure
13-5
).
Figure 13-5.
The Alter-Profile and Drop-Profile Statements
Note:
The CASCADE option on the
Drop-Profile
statement instructs Oracle to
reassign all user accounts formerly assigned to the profile, to the DEFAULT profile.