What is a profile?
What is a profile?
Rating:
A profile is a named set of limitations on database resources. It limits the resources consumed by a database user. It enables a database administrator to manage groups of users by limiting resource consumption and setting password policies. A profile can be assigned only to database users. It cannot be assigned to roles or other profiles. A database user can be assigned only one profile. If a profile is assigned to a user who is already assigned a profile, the new profile assignment overrides the previously assigned profile. When a profile is assigned to a database user who is currently connected to the database, the profile takes effect only after the user re-connects to the database. Also, changes made to a profile assigned to a database user take effect only after the user re-connects to the database.
Rating:
Other articles
- What is the SYSTEM tablespace?
- What is LOG_CHECKPOINT_TIMEOUT?
- What is Oracle's password aging and expiration feature?
- What is CORE_DUMP_DEST?
- What is DECODE function?