Profiles Editor (Oracle)
Go Up to Oracle Object Editors
The Profiles Editor lets you manage limits and manage user assignments for the profile.
To edit a profile
- Open an editor on the profile. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab | Settings and tasks | |
---|---|---|
Resources |
Lets you work with settings in the following categories: | |
General Limits |
Lets you specify Composite Limit and Private SGA settings. | |
Session Limits |
Lets you specify the limit on the amount of private space a session can allocate in the shared pool of the SGA. Specific settings are Sessions Per User, CPU Per Session, Logical Reads. | |
Time Limits |
Lets you specify the limit on total connection time per session. Specific settings are Connect Time and Idle Time. | |
Call Limits |
Lets you specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds. Specific settings are CPU Per Call and Logical Reads. | |
Login Limits |
Lets you specify the number of Failed Login Attempts on the user account before the account is locked and the Account Lock Time. | |
Password Limits |
Lets you specify the Lifetime, Reuse Time, Reuse Max, Grace Period and a Verify Function for passwords. | |
Users |
Use the Assign button to open a dialog that lets you assign a user to this profile or select a user from the list, and click the Unassign button to open a dialog prompting you to confirm that the user is to be unassigned. | |
DDL |
For details on using this tab, see Viewing the SQL/DDL for an Object. |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.