Profiles Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Profiles Editor lets you manage limits and manage user assignments for the profile.

To edit a profile

  1. Open an editor on the profile. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


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.


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.


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.