Profile Editor
Use the Profile Editor to view, create or alter profiles.
|
About Profiles |
A profile is a set of limits on the use of database resources that can be applied to a user. If you assign the profile to a user, that user cannot exceed those limits. If a user exceeds a limit, Oracle aborts and rolls back the transaction, and then ends the session. Profile settings include connect time, password lifetime and reuse, idle time, and similar restrictions. The characteristics and usage of this database object are described in Oracle documentation. |
Requirements
To edit profiles:
- You must have the CREATE PROFILE system privilege.
- Query the Oracle Data Dictionary with DBA Views. For more information, see DBA Dictionary Views.
Ways to Open The Profile Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | Profile Editor |
Open the Profile Editor. |
 |
From DB Navigator Right click on a Profile object and click Open. |
Open the selected Profile object in the Profile Editor. |