What is the DEFAULT profile?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the DEFAULT profile?
Rating:
Every Oracle database contains a special profile named DEFAULT. It is automatically created at the time of database creation. If a database user is not explicitly assigned a profile, Oracle automatically assigns the DEFAULT profile to the database user. The DEFAULT profile includes all database resources. Initially, all resources in the DEFAULT profile are set to UNLIMITED, which specifies that no limit is set for the resources. However, to prevent unlimited resource usage, the DEFAULT profile can be altered to set a certain limit for resources. The DEFAULT profile cannot be dropped.
Rating:
Was this information helpful?
Other articles
- What is LOG_CHECKPOINT_TIMEOUT?
- What is an extent?
- TheDatabase Configuration Assistant (DBCA) FEATURE
- What is Data Pump?
- What are dynamic performance views?